I am trying to install pgadmin3_91.i386 0:1.16.0-1.rhel5 on a centos 5.7
Currently installed license keys are:
RPM-GPG-KEY-beta RPM-GPG-KEY-EPEL RPM-GPG-KEY-PGDG
RPM-GPG-KEY-CentOS-5 RPM-GPG-KEY-linux-ink RPM-GPG-KEY-PGDG-91
Postgresql version installed is 9.1, not the default 8.4
po
I got a way which works fine: use bigint first, and then convert it to bit(32),
and convert it to int4 at last.
declare i integer := 0;
declare h bigint := 0;
begin
for i in 1..length(str) loop
h = (h * 31 + ascii(substring(str, i, 1))) & 4294967295;
end loop;
return cast(cast(h as bit(
I got a way which works fine: use bigint first, and then convert it to bit(32),
and convert it to int4 at last.
declare i integer := 0;
declare h bigint := 0;
begin
for i in 1..length(str) loop
h = (h * 31 + ascii(substring(str, i, 1))) & 4294967295;
end loop;
return cast(cast(h as bit(