Subject | Re: [firebird-support] FB 2.1: GTT explanation |
---|---|
Author | Vlad Khorsun |
Post date | 2008-04-21T12:22:42Z |
> I'm reading release notes, and I saw this about GTT:No, this is not possible in both directions.
> "references between persistent and temporary tables are forbidden"
>
> So it isn't possible to do something like this? if yes, is it possible
> to know the reason?
>
> create table t1 (
> field integer unique
> );
>
> create global temporary table gtt (
> field integer references t1(field)
> );
>
> or is there only a restriction about static tables referencing temporary?
Reasons is : (a) SQL Standard and (b) practical.
Regards,
Vlad