Select question - Mailing list pgsql-sql

From Chris Ruprecht
Subject Select question
Date
Msg-id 00a801c0e38b$94792320$5dd26383@corp.compucom.com
Whole thread Raw
Responses Re: Select question
Re: Select question
List pgsql-sql
Hi all,

although not new to databases, I'm new to the wonderful world of PostGreSQl
and SQL in general.
Question:

I do this query
phone=# select * from phonelog where cdate > 2001-05-18 order by cdate limit
2 ;

And I get theis result
  cdate    | ctime | countrycode | success | carrier | duration |
phonenumber | areacode | pseq
------------+-------+-------------+---------+---------+----------+----------
---+----------+------2001-04-01 |     0 |         370 |       1 |       1 |        8 | "3703348"
| "33"     | 40052001-04-01 |     0 |          98 |       1 |       1 |       15 | "9871162"
| "71"     | 3889


Although I specified that I want only dates > 5/18/2001, I get dates
4/1/2001. Clearly, I ask the system the wrong question. How do I ask this
question the correct way?

Best regards,
Chris


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-sql by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: Truncation of char, varchar, bit, varbit types (fwd)
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: index/join madness