On 23/08/2012 12:59, Dimitry Sibiryakov wrote: > 23.08.2012 17:52, Adriano dos Santos Fernandes wrote: >> But maybe we can return NULL for views of more than one table and >> maintain it as a number? At first, I'm more for that. > No, it must return version from real table record. Like this: > > create view v (a,b) as select t1.rdb$record_version, t2.rdb$record_version > from t1,t2 > > If the name is used without table alias in multitable select, it should > return usual > error "Ambiguous column reference", IMHO. > I'm talking about:
create view v as select t1.*, t2.* from t1, t2; select v.rdb$record_version from v; For dbkeys, Firebird concatenates dbkeys from t1 and t2. Concatenate with numeric version does not make sense. Adriano ------------------------------------------------------------------------------ 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
