> > => select now()>coalesce('Jul 14 2006 9:16:47AM');

> The only bug I see here is that implicit coercions to text 
> are a bad idea :-( --- IMHO it would be better if your first 
> query failed instead of giving you unexpected behavior.

:-) We know that you think that Tom, but a lot of us do not 
want to go casting all our sql, especially where other db's don't
require it.

Would an equivalent CASE statement also do the early conversion to text
? 

Andreas

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to