sorry, it's just a typo. I thought it is 6.5.1 bug, that why I ask before
I do anything. the behind-the-right-version mind-set is really bad.
---------- Forwarded message ----------
Date: Wed, 8 Mar 2000 10:37:17 -0600 (CST)
From: kaiq@picasso.realtyideas.com
To: pgsql-general@postgreSQL.org
Subject: mydate >'TODAY' not working on 6.5.1 with dbi
I used
select mls,city,price,numbed,fb,ohsdate,ohystime,ohetime,address,dir,rem,
apid,brokerid from mls where ohflag>0 and ohdate >= 'TODAY'
it works thro psql, but when I use it through dbi, it does not work.
note that the query without >='TODAY' works fine:
select mls,city,price,numbed,fb,ohsdate,ohystime,ohetime,address,dir,rem,
apid,brokerid from mls where ohflag>0
anybody ideas? thanks in advance!