Thanks. Attached patch applied. Good eye.
---------------------------------------------------------------------------
Rod Taylor wrote:
> time '05:00' + interval '2 hours' <== Shown below beside the '-' Name.
>
> date '2001-09-28' + interval '1 hour' <== also shown beside the '-'
> Name.
>
>
>
> The results look appropriate however, so flipping the +'s to -'s
> should be enough.
>
>
>
> Table 4-16. Date/Time Operators
>
> Name Example Result
> + timestamp '2001-09-28 01:00' + interval '23 hours' timestamp
> '2001-09-29 00:00'
> + date '2001-09-28' + interval '1 hour' timestamp '2001-09-28
> 01:00'
> + time '01:00' + interval '3 hours' time '04:00'
> - timestamp '2001-09-28 23:00' - interval '23 hours' timestamp
> '2001-09-28'
> - date '2001-09-28' + interval '1 hour' timestamp '2001-09-27
> 23:00'
> - time '05:00' + interval '2 hours' time '03:00'
> - interval '2 hours' - time '05:00' time '03:00:00'
> * interval '1 hour' * int '3' interval '03:00'
> / interval '1 hour' / int '3' interval '00:20'
>
> --
> Rod Taylor
>
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
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
? bookindex.sgml
? setindex.sgml
? catalogs.gif
? connections.gif
Index: func.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.91
diff -c -r1.91 func.sgml
*** func.sgml 2002/01/20 22:19:55 1.91
--- func.sgml 2002/01/25 02:38:20
***************
*** 2554,2566 ****
<row>
<entry> <literal>-</literal> </entry>
! <entry><type>date</type> '2001-09-28' + <type>interval</type> '1 hour'</entry>
<entry><type>timestamp</type> '2001-09-27 23:00'</entry>
</row>
<row>
<entry> <literal>-</literal> </entry>
! <entry><type>time</type> '05:00' + <type>interval</type> '2 hours'</entry>
<entry><type>time</type> '03:00'</entry>
</row>
--- 2554,2566 ----
<row>
<entry> <literal>-</literal> </entry>
! <entry><type>date</type> '2001-09-28' - <type>interval</type> '1 hour'</entry>
<entry><type>timestamp</type> '2001-09-27 23:00'</entry>
</row>
<row>
<entry> <literal>-</literal> </entry>
! <entry><type>time</type> '05:00' - <type>interval</type> '2 hours'</entry>
<entry><type>time</type> '03:00'</entry>
</row>
