From: | Asher Hoskins <asher(at)piceur(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: to_timestamp() and quarters |
Date: | 2010-03-04 13:12:36 |
Message-ID: | 4B8FB1C4.10509@piceur.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
A. Kretschmer wrote:
> In response to Tom Lane :
>> Asher Hoskins <asher(at)piceur(dot)co(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Graf | 2010-03-04 14:14:53 | Re: Scratching my head why results are different between machines. |
Previous Message | Magnus Hagander | 2010-03-04 11:53:40 | Re: Failed to run initdb: 128 |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-03-04 14:46:08 | Re: Linux start script updates |
Previous Message | Kevin Grittner | 2010-03-04 12:48:18 | Re: problem about inet |