logo       

base36 sequence: msg#00227

db.postgresql.novice

Subject: base36 sequence

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?


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise