"Alan T. Miller" <amiller@hollywood101.com> writes:
> If I create a table and assign the column type for what will be the primary
> key the value of "Serial", do I need to explicitly create an index in
> addition?
Either PRIMARY KEY or UNIQUE implies an index (for any column datatype).
They even put out notices to tell you so.
> I was thinking that a Serial, would automatically be a Unique Index wouldn't
> it?
Not in recent releases --- a SERIAL column is just an integer with a
special default value.
regards, tom lane
