Re: [BUGS] problem with query in postgres 6.5

2002-07-12 Thread Tom Lane
"praveen vejandla" <[EMAIL PROTECTED]> writes: > Can you pls let me know if there is any solution for this. Update your 6.5 installation. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once

[BUGS] problem with query in postgres 6.5

2002-07-12 Thread praveen vejandla
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 sol