tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

Computed by column with select in definition

3 Feb 2008 1 mins Firebird

Imagine, you want to create computed by column with select in definition (on Firebird, of course). I never needed this, and I thought, it’s not possible (from some trivial tests). But Slavek Skopalik demonstrated me the opposite. There’s a tricky part with braces (you have to be strict and keep syntax). So you have to write ... computed by ((select x from y ...)) .... Cool, isn’t it? 😉

Profile Picture Jiří Činčura is an independent developer, .NET, C# and Firebird expert, focusing on data and business layers, language constructs, parallelism, databases and performance. He's Microsoft Most Valuable Professional and frequent speaker. You can read his articles, guides and tips and tricks at www.tabsoverspaces.com.