Path: utzoo!utgpu!utstat!jarvis.csri.toronto.edu!mailrus!cornell!uw-beaver!uw-june!uw-entropy!quick!athens!midkiff
From: midkiff@Thalatta.COM (Michelle Midkiff)
Newsgroups: comp.databases
Subject: Re: Nesting SQL Commands?
Keywords: nesting, SQL, functions
Message-ID: <294@athens.Thalatta.COM>
Date: 20 Apr 89 16:57:14 GMT
References: <4YGLTiy00VA-MCvmVY@andrew.cmu.edu>
Reply-To: midkiff@Thalatta.COM (Michelle Midkiff)
Organization: Thalatta Corporation, Bellevue WA
Lines: 13

In article <4YGLTiy00VA-MCvmVY@andrew.cmu.edu> dp22+@andrew.cmu.edu (David Bruce Pinkus) writes:
>     Is there an implementation of SQL around that will allow functions
>to be nested in the same where clause?
>i.e.
>
>   WHERE    AVG(Col1 + Col2) = MIN(AVG(Col1+Col2))


Yes, I have implemented nested SQL functions in Oracle.
-- 

In-Real-Life: Michelle Midkiff, Thalatta Corporation, (+1 206 455 9838)
Domain: midkiff@Thalatta.COM    Path: ...!sun!sunup!thebes!midkiff