[Zope-DB] Assign query result(nextval) to variable

Andrew Veitch andrew@logicalprogression.net
Fri, 02 May 2003 17:11:28 +0100

> select nextval('project_sequence_id_key'::text);
> How do I assign this obtained value to a variable that can be inserted
> into columns?

What you want to do is use currval('project_sequence_id_key') which will
give you the current value.


Logical Progression Ltd, 20 Forth Street, Edinburgh EH1 3LH, UK
Tel: +44 (0)131 550 3733 Web: http://www.logicalprogression.net/