Re: [GENERAL] to_timestamp() and quartersf - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] to_timestamp() and quartersf
Date
Msg-id 13221.1267637850@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] to_timestamp() and quartersf  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [GENERAL] to_timestamp() and quartersf
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Here is an updated patch that honors 'Q' only if the month has not been
> previously supplied:

That's just weird.  It's not even self-consistent much less
unsurprising --- having the behavior be dependent on field order is
really horrid.

I think what people would actually want for this type of situation is
a way to specify "there is an integer here but I want to ignore it".
Q as it's presently constituted accomplishes that, though it is not
documented as doing so.  Brendan's comment about quoted text is
interesting, but it doesn't really solve the problem because of the
possibility of the integer field being variable width.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: [GENERAL] to_timestamp() and quarters
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: double and numeric conversion