Create artificial key without temp sequence

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Create artificial key without temp sequence
Date: 2007-10-16 07:10:00
Message-ID: ff1o3f$182i$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to create an artificial key, something that numbers rows of a
record set. I used to use temp sequences for that, but as I'm inside
pl/pgsql, its OID cache constantly bites me. What other options are there?

Thanks in advance.

--
Regards,
Hannes Dorbath

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2007-10-16 07:19:53 Re: can I define own variables?
Previous Message Sascha Bohnenkamp 2007-10-16 06:55:11 problem with a column of type timestamp