From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
Cc: | Marc Grimme <grimme(at)atix(dot)de>, Postgres Hackers List <hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key |
Date: | 1999-02-20 16:17:19 |
Message-ID: | 36CEE00F.CCAA0DAB@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
> > if I create a table like this:
> > CREATE TABLE test (
> > id decimal(3) primary key,
> > name varchar(32));
<snip>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Daryl W. Dunbar | 1999-02-20 16:26:12 | RE: [HACKERS] Major bug, possible, with Solaris 7? |
Previous Message | Hannu Krosing | 1999-02-20 16:09:44 | A few questions (was: SQL-Query 2 get primary key) |
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1999-02-21 15:45:24 | Re: [SQL] INSERT query (using insert from a Java application, concerning String input) |
Previous Message | D'Arcy J.M. Cain | 1999-02-20 13:18:52 | Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key |