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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Lebedev | 2002-09-30 18:39:19 | 7.2.1 to 7.3b1 |
Previous Message | scott.marlowe | 2002-09-30 18:28:51 | Re: how do i find out how long a query took? |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-09-30 18:47:15 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Hannu Krosing | 2002-09-30 18:35:57 | Re: (Fwd) Re: Any Oracle 9 users? A test please... |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-09-30 18:47:15 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Camila Rocha | 2002-09-30 18:29:59 | rows in order |