| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Cc: | elein <elein(at)varlena(dot)com>, Vincent Hikida <vhikida(at)inreach(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fw: Is SQL silly as an RDBMS<->app interface? |
| Date: | 2003-07-21 19:57:33 |
| Message-ID: | 200307211957.h6LJvXL09327@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-21 20:01:03 | Re: [GENERAL] INSTEAD rule bug? |
| Previous Message | Jim C. Nasby | 2003-07-21 19:57:10 | Re: Billions of records? |