Re: [GENERAL] Fwd: Re: Dynamic update of a date field

2012-02-19 Thread Jasen Betts
On 2012-02-16, David Salisbury wrote: > > > On 2/16/12 7:27 AM, Andreas Kretschmer wrote: >> Musial, Jan (GIUB) wrote: >>> smallint,month smallint,day smallint,time_stamp date); I would like to >> >> That's silly, use one (and only one) field, timestamp (or timestamptz) >> Don't use never ever mu

Re: [GENERAL] Fwd: Re: Dynamic update of a date field

2012-02-19 Thread Jasen Betts
On 2012-02-17, Steve Crawford wrote: > On 02/16/2012 02:45 PM, John R Pierce wrote: >> On 02/16/12 2:34 PM, David Salisbury wrote: >>> >>> Would it not be advantageous to replicate information in the above >>> form if you wanted to, say, get all records in the month of May, and >>> therefore creat