Bad Docs example

From: "Rod Taylor" <rbt(at)barchord(dot)com>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Bad Docs example
Date: 2002-01-24 02:32:16
Message-ID: 006101c1a47f$577d5d00$8001a8c0@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-01-24 03:07:20 Query taking a long time...
Previous Message Don Baccus 2002-01-24 02:05:36 Re: Savepoints