Hi :
In the PostgreSQL 7.2.1 SQL Reference manual I
encountered the following syntax under the "ALTER
TABLE" section.
ALTER TABLE table
ADD <table constraint definition>
ALTER TABLE [ ONLY ] table [ * ]
ADD [ COLUMN ] <column> <type> [
<column_constraint> [ ... ] ]
1) Is <table constraint definition> similar to
<column_constraint>?
2) Is the column <column_constaint> in ALTER TABLE the
same the <column_constraint> found under the section
"CREATE TABLE" ?
3) If a table w/ primary doesn't have any index. Does
it perform a sequential scan on the key columns before
inserting a new record?
4) If primary keys utilizes index, is a multi-column
index on multi-columned key a better implementation
over creating a seperate index for each column in the
primary key?
Thank you in advance,
ludwig
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
