On Sun, 2008-09-21 at 15:07 -0400, Andrew Dunstan wrote: > > Simon Riggs wrote: > > No, its not possible. Need a trigger. > > > > I think we should support it though. If we extend the relational model > > with arrays then it would be sensible if we support this aspect as > > well. > > > > Implementation would be fairly straightforward. ri_triggers currently > > assumes a non-array value is being checked, but that could be changed to > > IN(array). Multi-column keys with arrays sound confusing though. > > > > What's the syntax going to look like?
The ALTER TABLE would have exactly the same syntax. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
