Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id A2A5F4758DB
	for <pgsql-docs@postgresql.org>; Fri,  3 May 2002 04:47:01 -0400 (EDT)
Received: from finch-post-12.mail.demon.net (finch-post-12.mail.demon.net
	[194.217.242.41])
	by postgresql.org (Postfix) with ESMTP id 840E947589E
	for <pgsql-docs@postgresql.org>; Fri,  3 May 2002 04:47:00 -0400 (EDT)
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
	by finch-post-12.mail.demon.net with esmtp (Exim 3.35 #1)
	id 173YiJ-0009AS-0C
	for pgsql-docs@postgresql.org; Fri, 03 May 2002 08:46:55 +0000
Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly)
	by linda.lfix.co.uk with esmtp (Exim 3.35 #1 (Debian))
	id 173YiK-00035F-00
	for <pgsql-docs@postgresql.org>; Fri, 03 May 2002 09:46:52 +0100
Subject: timestamp() functions still documented
From: Oliver Elphick <olly@lfix.co.uk>
To: pgsql-docs@postgresql.org
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-zBfVu6ulBNIQ4y4gPySJ"
X-Mailer: Ximian Evolution 1.0.3 
Date: 03 May 2002 09:46:51 +0100
Message-Id: <1020415612.11662.17.camel@linda>
Mime-Version: 1.0
X-Archive-Number: 200205/1
X-Sequence-Number: 1359

--=-zBfVu6ulBNIQ4y4gPySJ
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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>
=20=20
-        <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>
-=20
-        <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?

--=20
Oliver Elphick                                Oliver.Elphick@lfix.co.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=20
      that weep."            Romans 12:15=20

--=-zBfVu6ulBNIQ4y4gPySJ
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA80k57YU1MND4dDBwRAvPLAJwOpaQ7KWH/AVo0ddfsMis3w7FbFgCeOSSO
VcluPZKct5mIEhCaILEVDIU=
=0iv2
-----END PGP SIGNATURE-----

--=-zBfVu6ulBNIQ4y4gPySJ--