On Sun, 2005-23-10 at 21:36 -0700, Josh Berkus wrote:
> SELECT id INTO v_check
> FROM some_table ORDER BY id LIMIT 1;
> IF id > 0 THEN ....
> ... that says pretty clearly to code maintainers that I'm only interested in
> finding out whether there's any rows in the table, while making sure I use
> the index on ID.
Why would you want to use the index on ID?
In response to
pgsql-performance by date
|Next:||From: Christopher Kings-Lynne||Date: 2005-10-24 05:03:03|
|Subject: Re: prepared transactions that persist across sessions?|
|Previous:||From: Josh Berkus||Date: 2005-10-24 04:36:35|
|Subject: Re: Using LIMIT 1 in plpgsql PERFORM statements|