From: andi <andi@mobile-elab.com>
To: pgsql-sql@postgresql.org
Subject: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
Date: Wed, 24 May 2006 17:35:10 +0700
Message-ID: <20060524103549.1E41C5AF071@svr4.postgresql.org> (raw)
Dear friends,
I have table
MD_CUSTOMER
MD_CUSTOMERIDPK integer primary key
NAME varchar
But my primary key is not in correct order like
MD_CUSTOMER
MD_CUSTOMERIDPK NAME
10
ANDI
33
TESTER
100 KKK
, so I want to make other primary key to generate sequences 1, 2, 3, . and
in MS SQL SERVER 2005
I can with Rank() function , but in Postgres how ?
PLEASE any one can help me, I am really appreciate.
Best regards
Andi kusnadi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andi@mobile-elab.com
Subject: Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
In-Reply-To: <20060524103549.1E41C5AF071@svr4.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox