Sha256: d320470e55f6cc2137aa0e1d9f18696bccc45cc52566eb1379f71a8ddaa4c2fa

Contents?: true

Size: 304 Bytes

Versions: 36

Compression:

Stored size: 304 Bytes

Contents

create or replace FUNCTION isalphanum(ch CHAR)
	RETURNS BOOLEAN as $$
	BEGIN
		if ascii(ch) between ascii('a') and ascii('z') or
			ascii(ch) between ascii('A') and ascii('Z') or
			ascii(ch) between ascii('0') and ascii('9')
		then
			return TRUE;
		end if;
		return FALSE;
	END;
$$ language 'plpgsql';

Version data entries

36 entries across 36 versions & 1 rubygems

Version Path
katello-3.18.5 db/functions/isalphanum_v01.sql
katello-3.18.4 db/functions/isalphanum_v01.sql
katello-3.18.3.1 db/functions/isalphanum_v01.sql
katello-3.18.3 db/functions/isalphanum_v01.sql
katello-3.18.2.1 db/functions/isalphanum_v01.sql
katello-3.18.2 db/functions/isalphanum_v01.sql
katello-3.17.3 db/functions/isalphanum_v01.sql
katello-3.18.1.1 db/functions/isalphanum_v01.sql
katello-3.17.2 db/functions/isalphanum_v01.sql
katello-4.0.0.rc1 db/functions/isalphanum_v01.sql
katello-3.18.1 db/functions/isalphanum_v01.sql
katello-3.18.0 db/functions/isalphanum_v01.sql
katello-3.17.1 db/functions/isalphanum_v01.sql
katello-3.16.2 db/functions/isalphanum_v01.sql
katello-3.18.0.rc2.1 db/functions/isalphanum_v01.sql
katello-3.18.0.rc2 db/functions/isalphanum_v01.sql
katello-3.17.0 db/functions/isalphanum_v01.sql
katello-3.18.0.rc1 db/functions/isalphanum_v01.sql
katello-3.17.0.rc2.2 db/functions/isalphanum_v01.sql
katello-3.17.0.rc2.1 db/functions/isalphanum_v01.sql