ninja <mail@schnake.freeserve.co.uk> writes:
> I'm very new to pgsql but I was wondering if it is possible to use
> CREATE SEQUENCE to make auto-increment base36 values for my ID column
> [varchar(252)]. I don't see any base convert function, though.
> Obviously, the reason I'm doing this is so as to maintain hierarchy. Is
> it possible or will I have to increment the sequence outside of pgsql?
If you don't mind my saying so, this seems like an exceedingly bizarre
requirement. Why don't you just use an integer column (or even more
specifically, a serial column) for your ID? Who could possibly care
about a base36 representation for a serial number as opposed to a
plain decimal representation?
FWIW, you could surely write your own display-in-base36 function in
plperl or pltcl. I'm just mildly astonished that you consider this
a significant issue.
regards, tom lane