Hi Paul,
PB> select code from codes where code_urn = (select nextval('code_urn_seq'));
Yes this is a great idea, but it only manages
one character. But I need a counter with
at least a variable length and it has to be
filled with leading zero-values, so that
the length of the generated counter value
is everytime I call the function the same.
Enrico Ortmann
----------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
