Hello it means - there are not operator LIKE for datatype date. Why do you do it? Try to look on date_part or extract functions.
Fast solution, bot not optimal, is cast date to text via function to_char(date, 'mask') regards Pavel Stehule 2009/4/12 Rohit Suman <handsome...@yahoo.com>: > 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: select * from bins where "Date In" like '%'; > ^ > HINT: No operator matches the given name and argument type(s). You might > need to add explicit type casts. > > In statement: > select * from bins where "Date In" like '%'; > > Please help...I'm stuck for like 3-4 hours now on this X_X > > Rohit > > ________________________________ > Add more friends to your messenger and enjoy! Invite them now. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
