Re: Bug #656: timestamp function generates parsing errors when - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: Bug #656: timestamp function generates parsing errors when
Date
Msg-id 200206022155.g52LthI09013@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug #656: timestamp function generates parsing errors when used as specified in the documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> pgsql-bugs@postgresql.org writes:
> > See the following session examples using the form given in the documentation.  'select timestamp(now());' fails
similarly.
>
> I'm afraid you've got bit by our continuing pursuit of SQL standard
> compliance.  The 7.2 release notes do point out:
>
> Observe the following incompatibilities:
>   *  The timestamp() function is no longer available. Use timestamp 'string' instead, or CAST.
>
> but I notice that the last two examples in Table 4-17 "Date/Time Functions"
> didn't get fixed.  (AFAICT there are no other places in current
> documentation that claim you can do that.)

I have removed those two timestamp() entries from the SGML table;  patch
attached.  I don't see any need to mention casting in that table.   In
fact, timestamp() was the only conversion function mentioned in that
table.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.98
diff -c -r1.98 func.sgml
*** doc/src/sgml/func.sgml    18 May 2002 13:47:59 -0000    1.98
--- doc/src/sgml/func.sgml    2 Jun 2002 21:51:45 -0000
***************
*** 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 ----

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bug #655: win32 client and bytea column
Next
From: Bruce Momjian
Date:
Subject: Re: PQescapeString and PQescapeBytea not exported during win