Ha. Why so it is. :)
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Nov 18, 2004, at 11:50 PM, Greg Stark wrote:
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
select 2004-06-08;
?column?
----------
1990
I'm not exactly sure how the bare string is converted internally, but
it's
clearly not a complete date like you're expecting.
What string? That's just integer arithmetic.
--
greg
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
