Re: Fw: Is SQL silly as an RDBMS<->app interface? - Mailing list pgsql-general

Jan Wieck wrote:
> elein wrote:
> > Quel rules.
>
> PostQUEL ... we should have kept a compatibility mode for that.

I prefer SQL for a few reasons:

    nested queries
    aggregates that make sense

Does anyone remember how QUEL had you put the qualifiction inside the
aggregate parens.  And the correlated aggregates were weird, sum(col1 by
col2 where col3 = ...).  It was a little subquery with a correlated
aggregate.  It still makes my head spin.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073