On Sat, Jan 15, 2005 at 03:11:22PM -0600, Jim C. Nasby wrote: > Would it make sense to have a version of currval that will only return > one value in a statement/transaction? So the first time it's called it > remembers what currval for that sequence is and always returns the same > value? What would nextval() do in that case? Return the nextval on the first call, and act like currval() from then until the end of the transaction? -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Porque francamente, si para saber manejarse a uno mismo hubiera que rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org