| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Brendan Jurd <direvus(at)gmail(dot)com>, Scott Bailey <artacus(at)comcast(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] to_timestamp() and quartersf |
| Date: | 2010-03-03 17:37:30 |
| Message-ID: | 13221.1267637850@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Bruce Momjian <bruce(at)momjian(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2010-03-03 17:44:33 | Re: How to grant a user read-only access to a database? |
| Previous Message | Brendan Jurd | 2010-03-03 17:22:52 | Re: [GENERAL] to_timestamp() and quarters |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaskiewicz | 2010-03-03 17:41:05 | Re: double and numeric conversion |
| Previous Message | Brendan Jurd | 2010-03-03 17:22:52 | Re: [GENERAL] to_timestamp() and quarters |