Skip site navigation (1) Skip section navigation (2)

Re: self defined counter function

From: Enrico Ortmann <pg(dot)admin(at)radax(dot)net>
To: "Paul Breen" <pbreen(at)computerpark(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: self defined counter function
Date: 2004-04-20 13:25:40
Message-ID: 808772948.20040420152540@radax.net (view raw or flat)
Thread:
Lists: 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

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



In response to

pgsql-admin by date

Next:From: Raquel VieiraDate: 2004-04-20 13:52:19
Subject: unsubscribe
Previous:From: Paul BreenDate: 2004-04-20 11:41:35
Subject: Re: self defined counter function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group