From: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
---|---|
To: | "Robert Haas" <robertmhaas(at)gmail(dot)com> |
Cc: | "Srinivas Naik" <naik(dot)srinu(at)gmail(dot)com>, "Mark Kirkwood" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Reg: SQL Query for Postgres 8.4.3 |
Date: | 2010-05-04 14:08:30 |
Message-ID: | 2cb731287c0d8773d8a839af9c960169.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-05-04 14:16:50 | Re: Reg: SQL Query for Postgres 8.4.3 |
Previous Message | Pavel Stehule | 2010-05-04 14:05:18 | Re: what is good solution for support NULL inside string_to_array function? |