Skip site navigation (1) Skip section navigation (2)

pgsql: Update ANSI INTERVAL section: < * Add support for ANSI time

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Update ANSI INTERVAL section: < * Add support for ANSI time
Date: 2005-03-23 21:10:03
Message-ID: 20050323211003.5A4FB535D0@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Update ANSI INTERVAL section:

< * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND
< * Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH
< * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision
< 
<   Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL
<   MONTH), and this should return '12 months'
< 
< * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
> * Add ANSI INTERVAL handling
> 	o Add support for day-time syntax, INTERVAL '1 2:03:04' 
> 	  DAY TO SECOND
> 	o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
> 	o Process mixed ANSI/PG syntax, and round value to requested
> 	  precision or generate an error
> 	o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
> 	  INTERVAL MONTH), and this should return '12 months'
> 	o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
> 	o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.1479 -> r1.1480)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1479&r2=1.1480)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-03-23 21:49:52
Subject: pgsql: Update item on ambiguous INTERVAL syntax: < o Add support for
Previous:From: Tom LaneDate: 2005-03-23 19:39:06
Subject: pgsql: Add note about risks involved in replaying CREATE TABLESPACE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group