Hey guys. Anyone have any idea how I could use a select statement in PostgreSQL with a wildcard without using a like/ilike match? I want to do:
SELECT * FROM table WHERE field >= '2008-%';
But it gives me an error saying it's an invalid input syntax (timestamp field). If I do a select where field LIKE or ILIKE the same expression, it works fine. And doing >= with a full timestamp works as well. It's just the >= and the % wildcard character that seems to be making it invalid.
Any ideas?
