Re: self defined counter function - Mailing list pgsql-admin

From Enrico Ortmann
Subject Re: self defined counter function
Date
Msg-id 808772948.20040420152540@radax.net
Whole thread Raw
In response to Re: self defined counter function  ("Paul Breen" <pbreen@computerpark.co.uk>)
List pgsql-admin
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

----------------------------------------



pgsql-admin by date:

Previous
From: "Paul Breen"
Date:
Subject: Re: self defined counter function
Next
From: CoL
Date:
Subject: Re: Going from a DB using SQL_ASCII to UNICODE