Re: [HACKERS] Reg: SQL Query for Postgres 8.4.3

2010-05-05 Thread Srinivas Naik
server for PostgreSQL 8.3. Servers for other major release versions can be installed simultaneously and are coordinated by the postgresql-common package. A package providing ident-server is needed if you want to authenticate remote connections with identd. Regards, Srinivas Naik On Wed, May 5

[HACKERS] Reg: SQL Query for Postgres 8.4.3

2010-05-04 Thread Srinivas Naik
database. I am using Postgresql 8.4.3 on Ubuntu 8.04 Thanks in Advance Regards, Srinivas Naik

Re: [HACKERS] Reg: SQL Query for Postgres 8.4.3

2010-05-04 Thread Srinivas Naik
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. On Tue, May 4, 2010 at 9:02 AM, Mark Kirkwood mark.kirkw...@catalyst.net.nz wrote: On 04/05/10 18:47, Srinivas Naik wrote: Hi, Can

Re: [HACKERS] Reg: SQL Query for Postgres 8.4.3

2010-05-04 Thread Srinivas Naik
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'0001' from 5 for -2); ERROR:invalid