| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: to_timestamp() and quarters |
| Date: | 2010-03-02 15:15:29 |
| Message-ID: | 20100302151529.GC25194@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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'.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonio Goméz Soto | 2010-03-02 15:24:49 | Re: How to grant a user read-only access to a database? |
| Previous Message | Raymond O'Donnell | 2010-03-02 15:14:53 | Re: How to grant a user read-only access to a database? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2010-03-02 16:00:27 | Re: USE_LIBXSLT in MSVC builds |
| Previous Message | Tom Lane | 2010-03-02 14:54:15 | Re: to_timestamp() and quarters |