Re: Reg: SQL Query for Postgres 8.4.3

On Tue, May 4, 2010 15:40, Robert Haas wrote:
> On Tue, May 4, 2010 at 7:46 AM, Srinivas Naik <naik(dot)srinu(at)gmail(dot)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