Re: [Firebird-devel] ODP: ODP: CORE-5997

2019-02-09 Thread Adriano dos Santos Fernandes
On 08/02/2019 16:54, Karol Bieniaszewski wrote: > > Or better sample > >   > > VAR_S[5] = VAR_A[3]; > > VAR_S[3] = VAR_A[5]; > >   > > Vs > >   > > VAR_S = SUBSTRING(VAR_S FROM 1 FOR 2) || SUBSTRING(VAR_A FROM 5 FOR 1) > || SUBSTRING(VAR_S FROM 4 FOR 1) || SUBSTRING(VAR_A FROM 3 FOR 1) ||

[Firebird-devel] ODP: ODP: CORE-5997

2019-02-08 Thread Karol Bieniaszewski
>>You ask for wrong thing. Instead of ask for a non standard feature that >>no DBMS made, and that completely changes SQL, you'd better ask for >>optimized PSQL execution. >>PSQL engine has none optimization currently. >>Adriano If this change something in string allocation on every change, than