Re: How do I select the last Id in a column???

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Josh Goldberg <josh(at)4dmatrix(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Michael Kovalcik <makd32(at)yahoo(dot)com>
Subject: Re: How do I select the last Id in a column???
Date: 2003-06-27 01:10:31
Message-ID: 20030627011031.GA11891@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jun 26, 2003 at 17:46:14 -0700,
Josh Goldberg <josh(at)4dmatrix(dot)com> wrote:
> From what Bruno enlightened us to about read commit mode, it seems this is
> the only safe way to go.
>
> Wouldn't currval (as presented by others) be affected in the same manner as
> my example?

No because currval returns the last value used in the current session.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-06-27 01:26:26 Re: 7.4 Documetation
Previous Message Josh Goldberg 2003-06-27 00:46:14 Re: How do I select the last Id in a column???