On Oct 16, 2007, at 12:57 , Tena Sakai wrote:
select name, value, datecreated
from mytable
where datecreated > 2007-10-02;
where datecreated > '2007-10-02'
2007-10-02 = 1995.
# select current_date < 2007-10-31 as arithmetic_comparison,
current_date < '2007-10-31' as date_comparison;
arithmetic_comparison | date_comparison
-----------------------+-----------------
f | t
(1 row)
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
