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

self defined counter function

From: Enrico Ortmann <pg(dot)admin(at)radax(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: self defined counter function
Date: 2004-04-20 07:56:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi admins,

I got a conceptual question on creating a stored procedure
I need for my app. First the description of the problem:

I need a counter which works with 36 possible values per
character [0-9 and thereafter A-Z].
That means if incremented it should return values as follows:

and so on.

My question is if anybody has already implemented such a
user-defined 'sequence' in PL/PGSql or if anyone has a great
idea on how to do that. The only solution I see at present is
to do that in PHP which is used to code the mentioned userland.

I suggest to solute on doing the following.

 - I create a sequence on the DBS
 - I get the next value of this sequence
 - I convert the next value in PHP in the code I need

The problem I see on doing this is that I always need to
convert if I want to get any kind of information about the
counter. For example it could be that I only want to know
what the last given value was. Because of the high traffic
value on the application I have to take care of, that the
information I read is quite correct at any time. So if I
have to convert the value of the sequence therefore I need
a little time. In the meantime the value could have changed
and my information is worthless.

I think the best way would be to code a store procedure
for the problem. Any ideas would be welcome.

Enrico Ortmann


pgsql-admin by date

Next:From: GPDate: 2004-04-20 08:08:12
Subject: Data replication
Previous:From: Ashvinder SinghDate: 2004-04-20 05:51:21
Subject: Using Cursor in PGSql ver 7.3

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