Re: [HACKERS] sub-selects in CHECK

2002-07-27 Thread Tom Lane
[EMAIL PROTECTED] (Neil Conway) writes: > Good point -- but given that SQL99 specifically mentions that this > functionality should be available (Feature 671, "Subqueries in > CHECK constraints"), there must be some reasonable behavior > adopted by another DBMS... It's effectively equivalent to a

Re: [HACKERS] sub-selects in CHECK

2002-07-27 Thread Neil Conway
On Sat, Jul 27, 2002 at 07:07:13PM -0400, Tom Lane wrote: > [EMAIL PROTECTED] (Neil Conway) writes: > > I'd like to add the ability to use a sub-select in a CHECK constraint. > > Can someone elaborate on what changes would be needed to support > > this? > > Define what you think should happen whe

Re: [HACKERS] sub-selects in CHECK

2002-07-27 Thread Tom Lane
[EMAIL PROTECTED] (Neil Conway) writes: > I'd like to add the ability to use a sub-select in a CHECK constraint. > Can someone elaborate on what changes would be needed to support > this? Define what you think should happen when the other rows referenced by the subselect change.