On 16/03/2022 00:45, Dmitry Yemanov wrote:
> 15.03.2022 21:43, Adriano dos Santos Fernandes wrote:
>>
>>> In fact, what you priorly define as LT is IMO "declared" LTT.
>>
>> I had that impression before read the standard, but then I changed my
>> opinion.
>
> "Part 4: Persistent Stored Modules
15.03.2022 20:14, Adriano dos Santos Fernandes wrote:
On 15/03/2022 14:02, Vlad Khorsun wrote:
SQL standard defines LOCAL TEMPORARY TABLES (LTT), which may be
"created" or "declared". The semantics of these standard specs are
different and not very easy applicable to Firebird as they are
15.03.2022 20:50, Adriano dos Santos Fernandes write:
On 15/03/2022 15:20, Vlad Khorsun wrote:
So CREATEd LTTs cannot be used in PSQL routines, only by DSQL?
At first look I see two way's to go:
a) PSQL routines can't see CREATE'd LTT's, or
b) PSQL routines can see and use LTT definition
15.03.2022 19:41, Dmitry Yemanov wrote:
Anyway, IMO "declared" LTTs are much more useful than "created" LTTs, so the latter ones may be deferred. Or we may live without
them at all ;-)
CREATE'd LTT's could be very useful to store\materialize intermediate results
of complex evaluations.
On 3/15/22 20:41, Dmitry Yemanov wrote:
15.03.2022 20:31, Alex Peshkoff via Firebird-devel wrote:
For me, "created" LTT is similar to GTT (i.e. stored in the
schema) but with data isolated per request (per PSQL routine).
I'd consider about CREATE'd LTT as attachment-private object. I see
