Select question

From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Select question
Date: 2001-05-23 13:23:39
Message-ID: 00a801c0e38b$94792320$5dd26383@corp.compucom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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" | 4005
2001-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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-05-23 14:02:09 Re: index/join madness
Previous Message J.H.M. Dassen Ray 2001-05-23 13:04:36 Re: Truncation of char, varchar, bit, varbit types (fwd)