Re: [Q] Sequences, last_value and inserts

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Q] Sequences, last_value and inserts
Date: 2002-11-01 20:22:43
Message-ID: m37kfx82gc.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Roderick A. Anderson" <raanders(at)acm(dot)org> writes:

> On Fri, 1 Nov 2002, Bruno Wolff III wrote:
>
> > You want to use currval. This can be used within a single session safely.
>
> I must be thick today.
>
> select currval from domain_info_tbl_key_seq;
> ERROR: Attribute 'currval' not found

Try:

select currval('domain_info_tbl_key_seq');

If you read the docs, you would know this. ;)

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2002-11-01 20:23:31 Re: [Q] Sequences, last_value and inserts
Previous Message Tom Lane 2002-11-01 20:18:59 Re: Update FROM clause?