Re: SQL (was: Why using "Group By")
Date: Fri, 14 Mar 2003 12:42:47 -0800
"Bob Badour" <bbadour_at_golden.net> wrote in message
> Post-relational will not evolve from SQL. It would require sufficient
> theoretical advances in mathematics or logic to develop a new logical
> based on new theory.
Why dismissing a possibility that ad-hoc SQL development might provide some insights before theory catches on?
> Do you have an example problem requiring recursion for which transitive
> closure provides no solution?
Please express 5! via transitive closure. You are not allowed to represent
multiplication as sum of logariphms (you wouldn't use transitive closure
with that approach, anyway). My solution
order by i
You may be right, but then
select sum(sal) from emp where 1=0
wouldn't return a row with 0. (Which it should no matter what SQL standard prescribes;-). I don't see how could I get around this problem, though. Received on Fri Mar 14 2003 - 21:42:47 CET