On 05/05/10 06:24, Srinivas Naik wrote:
I am sorry for that, but I made two different installations and I was messing up with various inputs.
Actually, the installed versions are below
postgresql-8.3
Ubuntu 8.10 with 2.6.27 Kernel
and its an 32Bit O/S
pgsql$ SELECT substring(B'1111000000000001' from 5 for -2);
ERROR:invalid memory alloc request size 4244635647
Please log into postgres do:
SELECT version();
(and Robert suggested) and show us the output - as we need to know the 3rd number e.g 8.3.x in the postgres version to help you any more.
regards
Mark