On Wed, Sep 22, 2010 at 10:01 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: > gnuoytr@xxxxxxx 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
