Hi Frank,
Am 30.11.2012 17:42, schrieb Frank Schlottmann-Gödde:
> On 29.11.2012 11:08, Frank Ingermann wrote:
>> Isn't it so that a CTE Select can only have one recursive member?
> I don't think so, because the construct we have problems with, already
> contains two
Hi Frank,
Am 29.11.2012 07:51, schrieb Frank:
> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
>
> No idea, anybody?
>
Isn't it so that a CTE Select can only have one recursive member?
(at least that's what i remember from Vlad's presentation back
in Bergamo, but i can't find a proof for
Hi Adriano,
Am 04.12.2011 19:36, schrieb Adriano dos Santos Fernandes:
> On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
>> On 16-11-2011 22:39, Frank Ingermann wrote:
>>> Hi all,
>>>
>>> i'm trying to combine the new Window functions in Fb3 w
Hi Claudio,
>> From: Frank Ingermann [mailto:fr...@fingerman.de]
>>
>> Still i think it's a no-go to just take the ability _away_ to
>> clear out those sources. It IS common practise.
(+1 for the COMMENTs!)
> The problem is that we lack equivalent commands for
Hi Helen e.a.,
Am 30.11.2011 19:32, schrieb Helen Borrie:
>>>On 11/30/11 02:42, Frank Ingermann wrote:
>>>> DROP SOURCE OF [||*]
>>>> or
>>>> CHANGE OWNER OF [|*] TO
>> I don't think bloat the language with non-standard syntax for
>
Hi Sean / *,
Am 29.11.2011 22:47, schrieb Leyne, Sean:
> Again, though how would that be done in SQL?
right - the original question was: can direct modification
of system tables be completely disabled, and (if yes):
what alternatives would we need...to still be able to do
what we do nowadays _wit
Hi Adriano,
Am 21.11.2011 20:04, schrieb Adriano dos Santos Fernandes:
> On 21/11/2011 16:45, Frank Ingermann wrote:
>> So this would mean option b) is correct:
>>
>> b) [ ] window functions are not supposed to work in the "child select"
>> part o
Hi,
Am 19.11.2011 01:04, schrieb Vlad Khorsun:
>>> Because standard prohibits any kind of aggregates in recursive CTE
>>> members.
>>>
So this would mean option b) is correct:
b) [ ] window functions are not supposed to work in the "child select"
part of recursive CTEs
- since Wind
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the recursive
child records in the result set.
Since we don't have "DEPTH FIRST BY " or
"BREADTH FIRST BY " clauses in recursive CTEs
yet, i'm trying to work around this by using the n
