| From: | John Hasler <john(at)dhh(dot)gt(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] CURRENT_TIMESTAMP |
| Date: | 2002-09-24 15:27:01 |
| Message-ID: | 87r8fj8l2y.fsf@toncho.dhh.gt.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
Josh Berkus writes:
> now() or now('transaction') returns the transaction timestamp.
> now('statement') returns the statement timestamp now('immediate') returns
> the timestamp at the exact time the function is called.
I like that.
IMHO "the exact time the function is called" is what most people would
expect to get from now(), but it's too late for that.
--
John Hasler
john(at)dhh(dot)gt(dot)org
Dancing Horse Hill
Elmwood, Wisconsin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-24 16:00:13 | Re: [GENERAL] CURRENT_TIMESTAMP |
| Previous Message | Ross J. Reedstrom | 2002-09-24 15:19:49 | Re: [GENERAL] CURRENT_TIMESTAMP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2002-09-24 15:38:46 | Re: Web site |
| Previous Message | Vince Vielhaber | 2002-09-24 15:26:55 | Re: Web site |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-24 16:00:13 | Re: [GENERAL] CURRENT_TIMESTAMP |
| Previous Message | Ross J. Reedstrom | 2002-09-24 15:19:49 | Re: [GENERAL] CURRENT_TIMESTAMP |