On Feb 22, 2008, at 8:38 AM, Dot Yet wrote:
that would mean Every row in foo for column f1 has to be unique and Every row in foo for column f2 has to be unique
The OP was asking about maintaining normal indexes on each in addition to the unique index on (f1, f2), not separate unique indexes.
Erik Jones DBA | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/