Re: Reg: SQL Query for Postgres 8.4.3
| От | Erik Rijkers |
|---|---|
| Тема | Re: Reg: SQL Query for Postgres 8.4.3 |
| Дата | |
| Msg-id | 2cb731287c0d8773d8a839af9c960169.squirrel@webmail.xs4all.nl обсуждение исходный текст |
| Ответ на | Re: Reg: SQL Query for Postgres 8.4.3 (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: Reg: SQL Query for Postgres 8.4.3
|
| Список | pgsql-hackers |
On Tue, May 4, 2010 15:40, Robert Haas wrote: > On Tue, May 4, 2010 at 7:46 AM, Srinivas Naik <naik.srinu@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
В списке pgsql-hackers по дате отправления: