Re: Best approach for a "gap-less" sequence - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 87veovwiwj.fsf@ieee.org
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr <mike@fuhr.org> writes:

>   Automatically use indexes for MIN() and MAX() (Tom)
>
>       In previous releases, the only way to use an index for MIN()
>       or MAX() was to rewrite the query as SELECT col FROM tab ORDER
>       BY col LIMIT 1.  Index usage now happens automatically.

Thanks Michael!  This is great.

--
Jorge Godoy      <jgodoy@gmail.com>


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Best approach for a "gap-less" sequence
Next
From: "Lee A Reum"
Date:
Subject: Re: problem with a dropped database