playpen=# create table jm( playpen(# jid int NOT NULL, playpen(# mid int , playpen(# UNIQUE(jid, mid) playpen(# ); NOTICE: CREATE TABLE/UNIQUE will create implicit index 'jm_jid_key' for table 'jm' CREATE Why isn't the index created called 'jm_jid_mid_key' ? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
