> This is by no means an obscure thing. In MySQL it's as
> simple as can be. Surely there is a straightforward way
> to deal with it in PostgreSQL?
Yes. Use normalized relations, where SQL is specifically designed to
deal with sets, to enforce uniqueness, etc etc. As you know, that
technique is portable to systems other than PostgreSQL too...
- Thomas