Stored Procedure - i am totally lost!!! - Mailing list pgsql-novice

From Marcel Boscher
Subject Stored Procedure - i am totally lost!!!
Date
Msg-id 41173FD3.2000406@emedia-office.de
Whole thread Raw
List pgsql-novice
Hey guys,

i got a question that bothers me quite a while,
been looking everywhere but found no answer

My idea is to automate this procedure for better performance...

Can anybody in here tell me if its possible to auto create
a 4 digit randomly code 1st digit alpha 2nd -4th numeric
that gets looked up in the db if its there new code is generated
if its not give the code back to my php proggy?
I would like to do it in PostGreSQl with a stored procedure

Any Help would be appreciated, since iam totally lost...
Thx in advance

pgsql-novice by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: lock entire database
Next
From: Oliver Fromme
Date:
Subject: Re: Design question regarding arrays