tabs ↹ over ␣ ␣ ␣ spaces

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? 😉

Jiří Činčura is .NET, C# and Firebird expert. He focuses on data and business layers, language constructs, parallelism, databases and performance. For almost two decades he contributes to open-source, i.e. FirebirdClient. He works as a senior software engineer for Microsoft. Frequent speaker and blogger at www.tabsoverspaces.com.