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

Re: [SQL] CURRENT_TIMESTAMP

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: josh(at)agliodbs(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Martijn van Oosterhout <kleptog(at)svana(dot)org>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Manfred Koizar <mkoi-pg(at)aon(dot)at>,Roland Roberts <roland(at)astrofoto(dot)org>, pgsql-sql(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] CURRENT_TIMESTAMP
Date: 2002-09-30 18:37:45
Message-ID: 3D9899F9.72BD773A@nsd.ca (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-sql
How can you make a difference between now('statement'), and
now('immediate').
To me they are the same thing. Why not simply now() for transaction, and
now('CLOCK') or better yet system_clock() or clock() for curent time.

JLL

Josh Berkus wrote:
> 
> Tom,
> 
> > I'd be happier with the whole thing if anyone had exhibited a convincing
> > use-case for statement timestamp.  So far I've not seen any actual
> > examples of situations that are not better served by either transaction
> > timestamp or true current time.  And the spec is perfectly clear that
> > CURRENT_TIMESTAMP does not mean true current time...
> 
> Are we still planning on putting the three different versions of now() on the
> TODO?  I.e.,
> now('transaction'),
> now('statement'), and
> now('immediate')
> With now() = now('transaction')?
> 
> I still think it's a good idea, provided that we have some easy means to
> determine now('statement').
> 
> --
> -Josh Berkus
>  Aglio Database Solutions
>  San Francisco
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

In response to

Responses

pgsql-hackers by date

Next:From: Jean-Luc LachanceDate: 2002-09-30 18:47:15
Subject: Re: [SQL] CURRENT_TIMESTAMP
Previous:From: Hannu KrosingDate: 2002-09-30 18:35:57
Subject: Re: (Fwd) Re: Any Oracle 9 users? A test please...

pgsql-sql by date

Next:From: Jean-Luc LachanceDate: 2002-09-30 18:47:15
Subject: Re: [SQL] CURRENT_TIMESTAMP
Previous:From: Camila RochaDate: 2002-09-30 18:29:59
Subject: rows in order

pgsql-general by date

Next:From: Oleg LebedevDate: 2002-09-30 18:39:19
Subject: 7.2.1 to 7.3b1
Previous:From: scott.marloweDate: 2002-09-30 18:28:51
Subject: Re: how do i find out how long a query took?

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