Re: Useless sort by

On Wed, Sep 22, 2010 at 10:01 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> gnuoytr(at)rcn(dot)com wrote:
>>
>> Spoken like a dyed in the wool COBOL coder.  The RM has no need for order;
>> it's set based.  I've dabbled in PG for some time, and my sense is
>> increasingly that PG developers are truly code oriented, not database (set)
>> oriented.
>
> I can't tell if you meant for this to be insulting or my reading it that way
> is wrong, but it certainly wasn't put in a helpful tone.  Let me summarize
> for you.  You've been told that putting ORDER BY into a view is a generally
> poor idea anyway, that it's better to find ways avoid this class of concern
> altogether.

It's been a few years since I've read the SQL spec, but doesn't it
actually forbid order by in views but pgsql allows it anyway?

Like you said, order by in a view is a bad practice to get into, and
it's definitely not what a "set oriented" person would do. it's what
a code oriented person would do.