Re: converting microsoft sql server 2000 sql-code for postgresql

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: Guy Fraser <guy(at)incentre(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
Date: 2003-01-29 08:31:05
Message-ID: 20030129083105.GB19737@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jan 28, 2003 at 23:39:47 -0500,
Wei Weng <wweng(at)kencast(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-01-29 09:01:39 Re: LONG - Question on dealing w/ numerics
Previous Message Bruno Wolff III 2003-01-29 08:28:38 Re: Cross-table constraints