Re: Sequence query

On Fri, Sep 14, 2001 at 01:19:42PM -0300, Tamara D. Blum wrote:
> I need to ask for the following secuence number for a field.
> I am connecting PostgreSQL with an ODBC Driver and with ADO.
> If i ask for the value of the field after updating the recordset, i get it is null (and it can't be), so i read how to ask for information about sequences and i founded that "SELECT * FROM objetos_ID_seq" would be ok, but i got an error: "The Relation 'objetos_Id_seq' does not exist".
>
> What's wrong ? Is there any problem with my sequence ?

select currval('my_sequence');

--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.