Re: Pet-peevishness ([GENERAL] When does a check constraint execute?)

2006-03-27 Thread Jim C. Nasby
On Mon, Mar 27, 2006 at 03:46:17PM +0200, Alban Hertroys wrote: > Jim C. Nasby wrote: > >On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED] > >wrote: > > > >If you only want to know if something exists, do NOT use count! > > > > > >>test$# (select * from test_dates t1 > >>test$#

Re: Pet-peevishness ([GENERAL] When does a check constraint execute?)

2006-03-27 Thread Alban Hertroys
Jim C. Nasby wrote: On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED] wrote: If you only want to know if something exists, do NOT use count! test$# (select * from test_dates t1 test$# where EXISTS ( select * from test_dates t2 test$# where (t1.from_date,