timestamp() functions still documented

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: pgsql-docs(at)postgresql(dot)org
Subject: timestamp() functions still documented
Date: 2002-05-03 08:46:51
Message-ID: 1020415612.11662.17.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2002-05-03 14:02:36 Re: timestamp() functions still documented
Previous Message Viktor Vislobokov 2002-04-30 06:43:18 Updated Russian version of FAQ