On 3/15/22 20:27, Dmitry Yemanov wrote:
15.03.2022 20:17, Vlad Khorsun 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.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
