dbTalk Databases Forums  

Re: ISO 8601 "Time Intervals" of the "format with time-unit

comp.databases.postgresql.patches comp.databases.postgresql.patches


Discuss Re: ISO 8601 "Time Intervals" of the "format with time-unit in the comp.databases.postgresql.patches forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: ISO 8601 "Time Intervals" of the "format with time-unit - 12-01-2003 , 08:12 AM






Peter Eisentraut wrote:
Quote:
Bruce Momjian writes:

Is this ready for application? It looks good to me. However, there is
an "Open issues" section.

It would be more useful to implement the SQL standard for intervals first
instead of inventing more nonstandard formats for it.
OK, patch removed from queue.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



Reply With Quote
  #2  
Old   
Ron Mayer
 
Posts: n/a

Default Re: ISO 8601 "Time Intervals" of the "format with time-unit - 12-01-2003 , 03:18 PM






Peter wrote:
Quote:
It would be more useful to implement the SQL standard for intervals first
instead of inventing more nonstandard formats for it.
Much of the postgresql docs talks about ISO-8601 formats, so I would think
of the patch more as a standards-based improvemnt for the current interval
shortand.

For example, where today postgresql accepts "1Y1M" as '1 year 1 minute',
with the patch, the ISO-8601-standard "P1Y1M" would mean '1 year 1 month'.

I would be happy to implement the SQL-standard-intervals as well if
someone can point me to that spec. It's just that the system I worked
with happend to exchange data with ISO8601 time intervals.

Ron Mayer

[Moderators of psql-patches... I first replied to Peter from a
separate (personal) account. I think this reply is now in the
moderation queue). In retrospect I thought it might be better if
the archives had the whole thread from the original email address.
If it's not too late, could you reject my post in the moderation queue?
If not, sorry for the spam.]



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.