Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi, better is walk throught tree -- WITH RECURSIVE R_TREE AS ( SELECT TT.ID, TT.ID AS TOP_PARENT FROM TABLE1 TT WHERE TT.PARENT_ID IS NULL UNION ALL SELECT TT.ID, RT.TOP_PARENT FROM TABLE1 TT JOIN R_TREE RT ON RT.ID =

Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2018. 05. 30. 16:51 keltezéssel, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] írta: > Recursive CTEs always make my head hurt, but if I understand the intent > correctly, you should replace it with: > > select ti.id, t.parent_id > from table1 t > inner join table1 root on t.parent_id =

RE: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Omacht András aoma...@mve.hu [firebird-support]
__ Information from ESET Mail Security, version of virus signature database 17471 (20180530) __ The message was checked by ESET Mail Security. http://www.eset.com

Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 30-5-2018 14:41, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > 2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu > [firebird-support] írta: >> Hi Gabor! >> >> You can do it with recursive cte: > > > First of all, thank you very much! But... > > I got "multiple rows in

Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2018. 05. 30. 16:04 keltezéssel, Omacht András aoma...@mve.hu [firebird-support] írta: > Hi Gábor! > > Now I can only test on 2.5.8, and it works: András, I tried now with 2.5.8 and got same error as with 3.0.3. Your TABLE1 contains all 12 rows? Gabor

RE: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Omacht András aoma...@mve.hu [firebird-support]
resources/documents/ ++ Yahoo Groups Links __ Information from ESET Mail Security, version of virus signature database 17470 (20180530) __ The message was checked by ESET Mail Security.

Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE

2018-05-30 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu [firebird-support] írta: > Hi Gabor! > > You can do it with recursive cte: First of all, thank you very much! But... I got "multiple rows in singleton select multiple rows in singleton select" (yes, double) error message with my

Re: Re: [firebird-support] Redirect output of gbak

2018-05-30 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Ach... thanks "%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 0 -STATISTICS TD -user SYSDBA -password masterkey %FB_BACKUP%\security3.bak%FB_RESTORE%\security3.fdb.restored > %FB_RESTORE%\rest.security3.rep 2>&1 regards, Karol Bieniaszewski W dniu 2018-05-30

Re: [firebird-support] Redirect output of gbak

2018-05-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.05.2018 10:45, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > it redirect info to the file but errors are not redirected - why? You forgot ">" before "%FB_RESTORE%\rest.security3.rep". -- WBR, SD.

[firebird-support] Redirect output of gbak

2018-05-30 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   how to redirect output of gbak to the file?     "%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 0 -STATISTICS TD -user SYSDBA -password masterkey %FB_BACKUP%\security3.bak      %FB_RESTORE%\security3.fdb.restored 2>&1