From: Oliver Elphick <olly@lfix.co.uk>
To: pgsql-docs@postgresql.org
Subject: timestamp() functions still documented
Date: 03 May 2002 09:46:51 +0100
Message-ID: <1020415612.11662.17.camel@linda> (raw)
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):
inline patch 1: doc/src/sgml/func.sgml (+0/-10 lines) download inline-1.patchIndex: 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.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
that weep." Romans 12:15
Attachments:
signature.asc (application/pgp-signature, 231B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: olly@lfix.co.uk
Subject: Re: timestamp() functions still documented
In-Reply-To: <1020415612.11662.17.camel@linda>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox