> something like this; SELECT currval('blahseq')
>
> I want to be able to set an object name for this value which
> is different
> to the field name that the SQL will return.
SELECT currval('blahseq') AS myname
should return a column named 'myname'.
Julian.