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) ||
>>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