Re: timestamp() functions still documented

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: timestamp() functions still documented
Date: 2002-06-02 22:19:37
Message-ID: 200206022219.g52MJbl11021@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


Patch applied.

---------------------------------------------------------------------------

Oliver Elphick wrote:
-- Start of PGP signed section.
> The functions timestamp(date) and timestamp(date, time) are still
> documented, but cannot be used because the parser interprets
> timestamp(xx) as timestamp with precision.
>
> So the documentation of those functions ought to be removed, because it
> confuses users (the same applies to the documentation of 7.2.1):
>
> Index: doc/src/sgml/func.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v
> retrieving revision 1.96
> diff -c -r1.96 func.sgml
> *** doc/src/sgml/func.sgml 2002/04/26 01:24:08 1.96
> --- doc/src/sgml/func.sgml 2002/05/03 08:40:01
> ***************
> *** 2730,2750 ****
> <entry><literal>Wed Feb 21 17:01:13.000126 2001 EST</literal></entry>
> </row>
>
> - <row>
> - <entry><function>timestamp</function>(<type>date</type>)</entry>
> - <entry><type>timestamp</type></entry>
> - <entry><type>date</type> to <type>timestamp</type></entry>
> - <entry><literal>timestamp(date '2000-12-25')</literal></entry>
> - <entry><literal>2000-12-25 00:00:00</literal></entry>
> - </row>
> -
> - <row>
> - <entry><function>timestamp</function>(<type>date</type>,
> <type>time</type>)</entry>
> - <entry><type>timestamp</type></entry>
> - <entry><type>date</type> and <type>time</type> to
> <type>timestamp</type></entry>
> - <entry><literal>timestamp(date '1998-02-24',time
> '23:07')</literal></entry>
> - <entry><literal>1998-02-24 23:07:00</literal></entry>
> - </row>
> </tbody>
> </tgroup>
> </table>
> --- 2730,2735 ----
>
>
> There are seven timestamp() functions in pg_proc and I don't think any
> of them can be used; should they not be removed or renamed?
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
>
> "Rejoice with them that do rejoice, and weep with them
> that weep." Romans 12:15
-- End of PGP section.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2002-06-03 17:18:42 Re: Documentation in German??
Previous Message Oliver Elphick 2002-06-02 04:39:30 Re: HOW TO APPLY PATCHES