Date: Sun, 29 Apr 2001 14:39:06 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: LeoDeBeo <leodebeo@hotmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: create table
Message-ID: <20010429143906.A27567@cc.usu.edu>
References: <9chq93$21vm$1@news.tht.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.17i
In-Reply-To: <9chq93$21vm$1@news.tht.net>;
	from leodebeo@hotmail.com on Sun, Apr 29, 2001 at 09:32:15PM +0200

On Sun, Apr 29, 2001 at 09:32:15PM +0200, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
> 
> CREATE [ TEMPORARY | TEMP ] TABLE table (
>         column type
>         [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
>         [ column_constraint_clause | PRIMARY KEY } [ ... ] ]
>         [ , ... ]
>         [ , PRIMARY  KEY ( column [, ... ] ) ]
>         [ , CHECK (condition) ]
>         [ , table_constraint_clause ]
>         ) [ INHERITS ( inherited_table [, ... ] ) ]
> 
> i don't understand what the curly brace means after PRIMARY KEY (where is 
> the other matching brace? ). It must have something to do with the fact 

	Means that you can optionally have several others of the prior. 

	PRIMARY KEY(column, column, column...)

> that a 'column type' pair ( with options ) can occur more than once, but is 
> this syntax right?

	AFAICS yes.

	-Roberto

-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Connection Attempt #172 ..<ring>...CONNECT 300.... <CLICK!>