Postgres Pro
Downloads
Home   >   mailing lists

Re: Data Type to represent a year/month value - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Data Type to represent a year/month value
Date
Msg-id 20020905124729.GA17658@nic.fr
Whole thread Raw
In response to Data Type to represent a year/month value  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
On Thu, Aug 29, 2002 at 08:25:11PM +0900,
 Jean-Christian Imbeault <jc@mega-bucks.co.jp> wrote
 a message of 14 lines which said:

> What would be the best data type to use to represent values of the kind
> year/month? I.e. 2002/10, 2003/01

I would use a regular time stamp with a convention to set the day and
the time to zero (may be with a trigger to ensure that the convention
is respected).

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: could not login as a root
Next
From: "Markus Wollny"
Date:
Subject: Problem with restoring dump (may be tsearch-related)