Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B10A5476865
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 04:06:48 -0500 (EST)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id 1F21F4776FD
	for <pgsql-sql@postgresql.org>; Wed, 29 Jan 2003 03:18:18 -0500 (EST)
Received: (qmail 19790 invoked by uid 500); 29 Jan 2003 08:31:05 -0000
Date: Wed, 29 Jan 2003 02:31:05 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Wei Weng <wweng@kencast.com>
Cc: Guy Fraser <guy@incentre.net>, Tom Lane <tgl@sss.pgh.pa.us>,
	pgsql-sql@postgresql.org
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
Message-ID: <20030129083105.GB19737@wolff.to>
Mail-Followup-To: Wei Weng <wweng@kencast.com>,
	Guy Fraser <guy@incentre.net>, Tom Lane <tgl@sss.pgh.pa.us>,
	pgsql-sql@postgresql.org
References: <000901c2c6b5$2deef350$240aa8c0@L1PC01>
	<200301281728.16020.mallah@trade-india.com>
	<3E36FCF0.5060305@incentre.net> <16682.1043805324@sss.pgh.pa.us>
	<003e01c2c750$74087e60$2f437242@PASCAL>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <003e01c2c750$74087e60$2f437242@PASCAL>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/478
X-Sequence-Number: 11343

On Tue, Jan 28, 2003 at 23:39:47 -0500,
  Wei Weng <wweng@kencast.com> wrote:
> What about a UNIQUEIDENTIFIER type?

You probably want to use serial type as a replacement. Serial is really
int with a default obtained using a sequence.