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.