Re: [GENERAL] CHECK constraints and optimizations

2004-05-06 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > On Thu, May 06, 2004 at 09:02:21PM -0400, Tom Lane wrote: >> Doubtless you could do it. The problem with the idea is that those >> inference tests are pretty expensive. > Is it really that expensive? I'm afraid it would be. You're correct tha

Re: [GENERAL] CHECK constraints and optimizations

2004-05-06 Thread Martijn van Oosterhout
On Thu, May 06, 2004 at 09:02:21PM -0400, Tom Lane wrote: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > I can't see why this wouldn't work. > > Doubtless you could do it. The problem with the idea is that those > inference tests are pretty expensive. I think that any such thing would

Re: [GENERAL] CHECK constraints and optimizations

2004-05-06 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > I can't see why this wouldn't work. Doubtless you could do it. The problem with the idea is that those inference tests are pretty expensive. I think that any such thing would waste significant numbers of cycles on ordinary queries while only b