Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-31 19:18:25
Message-ID: gm2861$n94$2@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-general
On 2009-01-29, Steve Crawford <scrawford(at)pinpointresearch(dot)com> wrote:
>
>>> 3. Date handling
>>> Sometimes I've got data with invalid dates and it would be great if it
>>> could replace all the bad ones with, say "0000-00-00".
>>>     

 0000-00-00 doesn't fit in a date column.
 perhaps you could use null?
 
 write a function that casts and catches the exception caused when bad 
 dates are attempted and returens null, use it to translate your data.
 


In response to

pgsql-general by date

Next:From: MohamedDate: 2009-01-31 19:21:17
Subject: Indices types, what to use. Btree, Hash, Gin or Gist
Previous:From: Jasen BettsDate: 2009-01-31 18:53:49
Subject: Re: getting no days problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group