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
no need to store its definition at the persistent schema.
If multiple procedures process the same layout of temporary data,
IMHO it's handier to create such LTT definition once (as persistent)
rather than declare the same LTT in the every procedure (or
attachment).
Same for almost all objects declared in procedure that are more
complex than INT. For example cursor definition may be rather complex
and also usable in multiple procedures.
True. But I don't remember CREATE CURSOR in the SQL spec ;-)
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
;-)
Taking into an account mentioned in this thread restriction:
a) PSQL routines can't see CREATE'd LTT's
I fully agree with you here.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
