Skip site navigation (1) Skip section navigation (2)

problem with query in postgres 6.5

From: "praveen vejandla" <praveen_vejandla(at)rediffmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem with query in postgres 6.5
Date: 2002-07-11 13:21:31
Message-ID: 20020711132131.8516.qmail@webmail10.rediffmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

I was able to run the below query successfully on PostgreSQL 
7.0.

SELECT substring(now() from 1 for 10);

How ever if I run the same query on PostgreSQL 6.5, I am getting 
the below error.

No such function 'substr' with the specified attributes.

Can you pls let me know if there is any solution for this.

Thanks and Regards,
Praveen
_________________________________________________________
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-07-11 13:34:57
Subject: Re: pg_dumpall forces plain text format
Previous:From: Justin CliftDate: 2002-07-11 13:06:16
Subject: Re: Postgres with IBM ????????

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group