Re: Best approach for a "gap-less" sequence

From: Jorge Godoy <godoy(at)ieee(dot)org>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Chris <dmagick(at)gmail(dot)com>, PostgreSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Best approach for a "gap-less" sequence
Date: 2006-08-14 13:23:24
Message-ID: 87veovwiwj.fsf@ieee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr <mike(at)fuhr(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Enke 2006-08-14 13:53:34 BUG #2574: C function: arg TEXT data corrupt
Previous Message Michael Fuhr 2006-08-14 12:16:06 Re: Best approach for a "gap-less" sequence