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.



Wed, 23 Jan 2002 21:32:16 -0500
"Rod Taylor" <rbt@barchord.com>
Bad Docs example
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>
Thu, 24 Jan 2002 21:39:03 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Bad Docs example