Received: from golem.jpl.nasa.gov (IDENT:root@hectic-3.jpl.nasa.gov [128.149.68.205]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA23454 for ; Sat, 20 Feb 1999 11:17:52 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost [127.0.0.1]) by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id QAA05249; Sat, 20 Feb 1999 16:17:19 GMT Sender: tgl@mythos.jpl.nasa.gov Message-ID: <36CEE00F.CCAA0DAB@alumni.caltech.edu> Date: Sat, 20 Feb 1999 16:17:19 +0000 From: "Thomas G. Lockhart" Organization: Caltech/JPL X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: "D'Arcy J.M. Cain" CC: Marc Grimme , Postgres Hackers List Subject: Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > if I create a table like this: > > CREATE TABLE test ( > > id decimal(3) primary key, > > name varchar(32)); > Note that this makes the assumption that only one field can be in the > primary key (no complex primary keys) but I don't think there will > ever be more than one the way we declare it now. fyi, the following syntax is allowed: CREATE TABLE test ( id decimal(3), name varchar(32), primary key(id)); and multiple columns can be declared as primary keys. - Tom