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

From Asher Hoskins
Subject Re: to_timestamp() and quarters
Date
Msg-id 4B8FB1C4.10509@piceur.co.uk
Whole thread Raw
In response to Re: to_timestamp() and quarters  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Failed to run initdb: 128
Next
From: Justin Graf
Date:
Subject: Re: Scratching my head why results are different between machines.