Re: [SQL] Re: [GENERAL] Frequently unable connecting to db "server doesn't listen"

2009-04-20 Thread Rohit Suman
I had a quite of similar problem earlier..it was with WAPPSTACK package that I had installed. Both the apache server and the postgresql stopped working. So, I had to uninstall and install both of them . After a day or two same thing happened. Then I scanned my PC using Avast Anti-Virus and there

Fw: [SQL] ERROR: operator does not exist: date ~~ unknown

2009-04-12 Thread Rohit Suman
Ya...I simply changed column type to text and it worked. :D I had requirements where I needed such a functionality. There was no way to do it any other way... Thanks man - Forwarded Message From: Pavel Stehule To: Rohit Suman Cc: pgsql-sql@postgresql.org Sent: Sunday, 12 April

[SQL] ERROR: operator does not exist: date ~~ unknown

2009-04-11 Thread Rohit Suman
Hi I've a table bins in which I've a column named "Date In" which stores values of "Date" type. I've postgresql 8.3.5 Now when I execute query " select * from bins where "Date In" like '%'; "I get the folowing error : SQL error: ERROR: operator does not exist: date ~~ unknown LINE 1: sele