Re: [Firebird-devel] More consistent syntax for computed columns and identity columns:

2013-08-30 Thread Mark Rotteveel
On Fri, 30 Aug 2013 16:28:37 +0200, Robbert-Jan rjm_eabonnem...@xs4all.nl wrote: Hi, I like to propose a more consistent syntax for computed columns and identity columns: Computed columns are now defined in DDL as ColumnName [DataType] GENERATED ALWAYS AS (Expression) while identity

Re: [Firebird-devel] More consistent syntax for computed columns and identity columns:

2013-08-30 Thread Robbert-Jan
Thanks Adriano, Sean and Mark, You are right. I do not no what I was thinking but specifying BY DEFAULT for computed columns makes indeed no sense. Kind regard, Robert On 30/08/2013 11:28, Robbert-Jan wrote: Hi, I like to propose a more consistent syntax for computed columns and identity

Re: [Firebird-devel] More consistent syntax for computed columns and identity columns:

2013-08-30 Thread Leyne, Sean
I also am not sure if a GENERATED BY DEFAULT AS ... makes sense for a computed column, as it would imply it is a normal column that has a default (which already has a separate clause) and not a computed one. That also struck me as odd. DEFAULT only makes sense for persisted fields, since

Re: [Firebird-devel] More consistent syntax for computed columns and identity columns:

2013-08-30 Thread Adriano dos Santos Fernandes
On 30/08/2013 11:28, Robbert-Jan wrote: Hi, I like to propose a more consistent syntax for computed columns and identity columns: Computed columns are now defined in DDL as ColumnName [DataType] GENERATED ALWAYS AS (Expression) while identity columns (as of FB 3.0 CORE-1385) are