Re: to_timestamp() and quarters - Mailing list pgsql-general

From Tom Lane
Subject Re: to_timestamp() and quarters
Date
Msg-id 15109.1267541655@sss.pgh.pa.us
Whole thread Raw
In response to to_timestamp() and quarters  (Asher Hoskins <asher@piceur.co.uk>)
Responses Re: to_timestamp() and quarters  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: to_timestamp() and quarters  (Scott Bailey <artacus@comcast.net>)
List pgsql-general
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'.

That might be a reasonable position, but it seems like it'd be better to
throw an error than silently do nothing.  Anybody know what Oracle does
with this?

            regards, tom lane

pgsql-general by date:

Previous
From: Antonio Goméz Soto
Date:
Subject: Re: How to grant a user read-only access to a database?
Next
From: Thom Brown
Date:
Subject: Re: How to grant a user read-only access to a database?