ODP: ODP: [firebird-support] Silly selection problem ...

2019-03-04 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>>Can you explain how? I do not study your topic much and i can be wrong here. But maybe you got the idea about what i am thinking about. SELECT (SELECT PRE.ITEM_CONTENT_ID FROM FISHEYE_GALLERY_IMAGE_MAP PRE WHERE

Re: ODP: [firebird-support] Silly selection problem ...

2019-03-04 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 04/03/2019 15:56, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > You can do this without window function also in FB<3, but less efective. > Do simple 2 subselects in your select. Can you explain how? Without the full window scan LAG and LEAD gave NULL ... --

ODP: [firebird-support] Silly selection problem ...

2019-03-04 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
You can do this without window function also in FB<3, but less efective. Do simple 2 subselects in your select. Regards, Karol Bieniaszewski