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 ;-)
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel