> Just discovered that column::date works fine but to_date(column, 'DD.MM.YY') > causes the problem. I was trying to write portable SQL, but never mind!
Portable (as in SQL9x) would be cast(column as date) which is also accepted by PostgreSQL... - Thomas ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly