From: Chris Ruprecht <chrup999@yahoo.com>
To: psql <pgsql-sql@postgresql.org>
Subject: Select question
Date: Wed, 23 May 2001 08:23:39 -0500
Message-ID: <00a801c0e38b$94792320$5dd26383@corp.compucom.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chrup999@yahoo.com
Subject: Re: Select question
In-Reply-To: <00a801c0e38b$94792320$5dd26383@corp.compucom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox