Re: [PATCHES] ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

2003-12-09 Thread Randolf Richardson 
[sNip]
 ISO 8601 gives more specific names.
 
   ISO 8601 Basic Format: P2Y10M15DT10H20M30S
   ISO 8601 Alternative Format:   P00021015T102030
   ISO 8601 Extended Format:  P0002-10-15T10:20:30
 
 In a way, the Extended Format is kinda nice, since it’s
 almost human readable.
 
 I could put in both the basic and extended ones, and
 call the dateformats “iso8601basic” and “iso8601extended”.
 The negative is that to do “iso8601basic” right, I’d also
 have to tweak the “date” and “time” parts of the code too.

Perhaps all three formats should be supported, and if the following 
names were all valid things could be simplified further too:

iso8601basic
iso8601bas
iso8601alternative
iso8601alt
iso8601extended
iso8601ext

The reason for allowing shorter names is to simplify database 
management for anyone who may need to store the format name in a column for 
some reason (I can't think of one now, but I get a feeling that someone 
will want to do this type of thing in the future).

For that matter, the first letter could be used instead of the first 
three for the short versions.  Any thoughts on this?

-- 
Randolf Richardson - [EMAIL PROTECTED]
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [PATCHES] clock_timestamp() and transaction_timestamp() function

2003-12-01 Thread Randolf Richardson 
 Yes, user-visible.  They give additional current timestamp information.
 transaction_timestamp() is the same as current_timestamp,
 clock_timestamp is the same as gettimeofday(), and statement_timestamp
 is a new one that shows statement start time.
 
 And what would be the point of that?

Bean counters love this stuff, especially during audits.  =D

-- 
Randolf Richardson - [EMAIL PROTECTED]
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org