> 23.08.2012 18:04, Adriano dos Santos Fernandes wrote:
> > I'm talking about:
> >
> > create view v as select t1.*, t2.* from t1, t2;
> >
> > select v.rdb$record_version from v;
>
> IMHO, it should give "Column unknown" error. I.e. this pseudocolumn must
> be defined for real tables only.
I tend to agree, but this introduces a distinction between Tables and Views
which doesn't exist for any other purpose.
For confirmation, this would be valid, correct?
create view v as
select
t1.rdb$record_version as T1_Version,
t2.rdb$record_version as T2_Version
from t1, t2
;
Sean
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
