Postgres Pro
Downloads
Home   >   mailing lists

Generate char surrogate key - Mailing list pgsql-general

From Josué Maldonado
Subject Generate char surrogate key
Date
Msg-id 405B4925.8010400@lamundial.hn
Whole thread Raw
Responses Re: Generate char surrogate key
List pgsql-general
Tree view 
Hello list,

Have a table with char(3) column, the column should contain values like
'001','002','003'... and so on, keys must be correlatives no
'001','005','007' should be allowed, any idea how to get it done using a
trigger?

Thanks in advance

--

Josué Maldonado

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Q: How do I return differnt rows depending on values
Next
From: Josué Maldonado
Date:
Subject: Re: Generate char surrogate key