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: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

I was able to run the below query successfully on PostgreSQL 

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,
There is always a better job for you at
Go now


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-2017 The PostgreSQL Global Development Group