Re: [GENERAL] CURRENT_TIMESTAMP - Mailing list pgsql-sql

From Manfred Koizar
Subject Re: [GENERAL] CURRENT_TIMESTAMP
Date
Msg-id 9ka0puk83umng8f1va1pjiti5gpksdto3j@4ax.com
Whole thread Raw
In response to Re: [GENERAL] CURRENT_TIMESTAMP  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [GENERAL] CURRENT_TIMESTAMP
List pgsql-sql
On Mon, 23 Sep 2002 13:36:59 -0700, Josh Berkus <josh@agliodbs.com>
wrote:
>I, for one, would judge that the start time of the statement is "during the 
>execution"; it would only NOT be "during the execution" if it was a value 
>*before* the start time of the statement.  It's a semantic argument.

Josh, you're right, I meant closed interval.

>Further, we could not change that behaviour without breaking many people's 
>applications.
>
>Ideally, since we get this question a lot, that a compile-time or 
>execution-time switch to change the behavior of current_timestamp 
>contextually would be nice.

Yes, GUC!

>We just need someone who;s interested enough in 
>writing one.

First we need someone who decyphers SQL99's wording.

ServusManfred


pgsql-sql by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP
Next
From: Manfred Koizar
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP