Subject | Re: [Firebird-general] RE: MySQL versus Firebird |
---|---|
Author | |
Post date | 2014-03-10T18:57:54Z |
---In firebird-general@yahoogroups.com, <sd@...> wrote :
10.03.2014 18:38, IJFQSFTGESJU@... wrote:
The tooltip (comments) says "Has UPDATE or INSERT"
create table foo (
bar varchar(20) default lower('current_user')
);
And that didn't work. Can you show me how to use a (built-in and my own) function as a default value?
> Computed columns,Ah, right. I'll change that, an oversight on my side (my SQL tool actually displays them correctly)
> MERGEIt is set to Yes. But in parentheses because there is no MERGE statement.
The tooltip (comments) says "Has UPDATE or INSERT"
> BOOLEAN, autoincrements and DDL triggers will be in 3.0.Yes but 3.0 is still not released.
> Functions as column defaults are enabled in Firebird,Really? I tried something like this:
create table foo (
bar varchar(20) default lower('current_user')
);
And that didn't work. Can you show me how to use a (built-in and my own) function as a default value?
> but not in Oracle (you cannot say DEFAULT seq.nextvalue for example).Yes, you can't use nextval before Oracle 12, but you can use any (deterministic) function as a column default.