Re: Composite types for composite primary/foreign keys?

On Nov 16, 2007, at 4:07 , Wolfgang Keller wrote:

> But I am pathetically lazy >;->, so I ld like to save keystrokes
> and thus I had the (maybe pathetic)idea to use composite types for
> the composite primary (and foreign) keys. No luck again, it seems
> to me, as according to the documentation: "since no constraints are
> associated with a composite type, the constraints shown in the
> table definition do not apply to values of the composite type
> outside the table".

Note: "do not apply to values of the composite type outside of the
table". Both primary keys and foreign keys are defined within tables,
so AIUI this statement does not preclude you from using composite
types as primary and foreign keys.

> I'm sorry, but I'm apparently too dump to actually figure out
> myself whether this means that I can use a single composite type
> column as a primary / foreign key or whether not...?

What have you actually tried? You can learn a lot by a few minutes of
exploration at a psql prompt.

Michael Glaesemann
grzm seespotcode net