Re: Index not being used - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Index not being used
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEGLCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Index not being used  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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)



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index not being used
Next
From: "Nick Fankhauser"
Date:
Subject: creating an index on a function