> On Monday 15 April 2002 03:53, Christopher Kings-Lynne wrote: > > BTW, instead of: > > > > CREATE UNIQUE INDEX bigone_pkey ON bigone (rec_no); > > > > do: > > > > ALTER TABLE bigone ADD PRIMARY KEY(rec_no); > > I am sorry, could you please elaborate more on the difference?
They have the same _effect_, it's just that the first sytnax does not mark the index as the _primary_ index on the relation. Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
