Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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>
- 	<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>,
- 	<entry><type>timestamp</type></entry>
- 	<entry><type>date</type> and <type>time</type> to
- 	<entry><literal>timestamp(date '1998-02-24',time
- 	<entry><literal>1998-02-24 23:07:00</literal></entry>
-        </row>
--- 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                    
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 


pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group