Re: to_timestamp() and quarters
Asher Hoskins <asher@piceur.co.uk>
From: Asher Hoskins <asher@piceur.co.uk>
To: pgsql-general@postgresql.org
Date: 2010-03-04T13:12:36Z
Lists: pgsql-hackers, pgsql-general
A. Kretschmer wrote: > In response to Tom Lane : >> Asher Hoskins <asher@piceur.co.uk> writes: >>> I can't seem to get to_timestamp() or to_date() to work with quarters, >> The source code says >> >> * We ignore Q when converting to date because it is not >> * normative. >> * >> * We still parse the source string for an integer, but it >> * isn't stored anywhere in 'out'. >> > > Ouch, sound like MySQL / myisam: we accept things like foreign key, but > we don't implement that... > > +1 for raise an error or something, but no 'accept & ignore'. Thanks for the replies, nice to know I wasn't doing something silly! +1 for raising an error/warning from me too, it would have saved me some fruitless googling. Thanks, Asher.