Re: to_timestamp() and quarters

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.

In response to

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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