| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Matthew Price" <pricem(at)juno(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Index not being used |
| Date: | 2002-02-15 04:06:11 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOGEGLCBAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> There is no such concept, at present. See the archives...
Then why does this work?:
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:35+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:36+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:37+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:38+08
(1 row)
australia=# begin transaction;
BEGIN
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:43+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:43+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:43+08
(1 row)
australia=# select current_timestamp;
timestamp
------------------------
2002-02-15 12:03:43+08
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2002-02-15 14:26:25 | creating an index on a function |
| Previous Message | Tom Lane | 2002-02-15 03:52:00 | Re: Index not being used |