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

2009-04-12 Thread Tom Lane
Rohit Suman writes: > 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... You should really, really take a second look at those "requirements". Applying a textual pattern match to a dat

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, 200