A. Kretschmer wrote:
In response to Tom Lane :
Asher Hoskins <asher@xxxxxxxxxxxx> 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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general