On Tue, May 4, 2010 15:40, Robert Haas wrote: > On Tue, May 4, 2010 at 7:46 AM, Srinivas Naik <naik.sr...@gmail.com> wrote: >> Hi Mark, >> >> Please find the below details: >> >> postgresql-8.3 >> >> and UBUNTU-8.10 with linux-image-2.6.27.18-standard_810_i386.deb >> >> and its an 32bit Ubuntu. > > Err, before you said 8.4.3. Now you're saying 8.3. Those are totally > different. Can we get the exact identifier of the package you have > installed, plus the output from > > SELECT version(); > fwiw, results for all current postgres versions:
-- to be executed: SELECT substring(B'1111000000000001' from 5 for -2); SELECT substring(B'1111000000000001' from 4 for -3); -- postgres 9.0beta1 ERROR: negative substring length not allowed ERROR: negative substring length not allowed -- postgres 8.4.3 000000000001 1000000000001 -- postgres 8.3.10 000000000001 1000000000001 -- postgres 8.2.16 000000000001 1000000000001 -- postgres 8.1.20 000000000001 1000000000001 -- postgres 8.0.24 000000000001 1000000000001 -- postgres 7.4.28 000000000001 1000000000001 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
