At 10:01 PM 28/06/2007, you wrote:

>Hi all!
>
>Is is possible in the Firebird to add new column and update value of
>this column in one transaction (I am moving app from PostgreSQL to FB)?
>
>Example:
>
>ALTER TABLE action ADD speedmod INTEGER;
>UPDATE action SET speedmod = 1;

No.

>Firebird output:
>SQL error code = -206
>Column unknown
>SPEEDMOD
>At line 2, column 19
>
>PostgreSQL output:
>OK

Different architecture.

./hb