Re: separation of church and state?
Date: Sat, 6 Oct 2007 20:11:05 +0100
Message-ID: <feqdnf77HdVPQJranZ2dneKdnZydnZ2d_at_giganews.com>
"David Cressey" <cressey73_at_verizon.net> wrote in message
news:X4PNi.3890$9r2.3214_at_trndny04...
>
> Oracle RDBMS, by contrast, has always forbidden ORDER BY in view
> definitions. Other than satisfying some people's need for doctrinaire
> purity, the RDBMS users gained nothing by this restriction.
>
>
Assuming you can define such a set of rules, how is the product supposed to behave when the user breaks the rules by issuing a query that cannot properly be ordered according to the view definition? Do we disallow such queries and raise an error or do we silently return a result set that isn't sorted? In the latter case, the user must be expected to understand when the rules are being broken and presumably must also know in advance what the ordering is supposed be. What benefit can the user possibly gain from this added complexity?
-- David PortasReceived on Sat Oct 06 2007 - 21:11:05 CEST