Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f4NGIcA45254
	for <pgsql-sql@postgresql.org>; Wed, 23 May 2001 12:18:38 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4NGIUR15038;
	Wed, 23 May 2001 12:18:30 -0400 (EDT)
To: "Chris Ruprecht" <chrup999@yahoo.com>
cc: "psql" <pgsql-sql@postgresql.org>
Subject: Re: Select question 
In-reply-to: <00a801c0e38b$94792320$5dd26383@corp.compucom.com> 
References: <00a801c0e38b$94792320$5dd26383@corp.compucom.com>
Comments: In-reply-to "Chris Ruprecht" <chrup999@yahoo.com>
	message dated "Wed, 23 May 2001 08:23:39 -0500"
Date: Wed, 23 May 2001 12:18:30 -0400
Message-ID: <15035.990634710@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200105/253
X-Sequence-Number: 3081

"Chris Ruprecht" <chrup999@yahoo.com> writes:
> phone=# select * from phonelog where cdate > 2001-05-18 order by cdate limit
> 2 ;

Try

select * from phonelog where cdate > '2001-05-18' order by cdate limit 2

I think it's interpreting your query as where cdate > 1978 (result of
integer subexpression) and then doing some weird integer-to-date
conversion.  In general, any constant of a non-numeric datatype needs
to be quoted in SQL queries.

			regards, tom lane