Hi,
Thank You for your reply.
BUT as i mentioned the date_time field is VARCHAR.
So if i use:
date >= '01/4/2000' and date < '01/5/2000'
this won't compare the dates it will compare Strings.
so '02/4/2000' will be GREATER than '01/5/2000'.
That is why i need a DATE TYPE for my field that can be used to create an
index.
So any other ideas?
----- Original Message -----
From: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
To: Andras Balogh <abalogh@grafx.ro>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, April 26, 2000 5:41 PM
Subject: Re: [GENERAL] pgsql DATE
> Andras Balogh wrote:
> > So i am looking a date type that would allow me to do the following with
one
> > (or a few) query
> > (and to be fast too):
> > -select all records for a given month
> > -select the count of records where the hour is 14.
> > -select all the records from the 7th week.
> > -select count of records where the day of the week is Sunday.
> > etc.
>
> How about you write your queries like:
>
> date >= '01/4/2000' and date < '01/5/2000'
>
> or equivalent. It allows use of the index but works the same.
> Except for the day is Sunday though...
> --
> Martijn van Oosterhout <kleptog@cupid.suninternet.com>
> http://cupid.suninternet.com/~kleptog/