On Thu, Aug 29, 2002 at 15:00:15 -0600, Clinton Adams <clinton@xxxxxxxxxxxxxx> wrote: > Chris - > > You don't really need to know the key values - make it one query: > > insert into c values (nextval('crecid'), currval('arecid'), currval('brecid')) Is it documented that the above is reliable? I don't remember ever reading that expressions are evaluated in the order they appear in a select statement.