Re: Feature request

[<Eugen(dot)Konkov(at)aldec(dot)com>]

There is situation where I check values and if they do not satisfy some 
condition I need to set default.
What is the best way to do that?

----- Original Message ----- 
From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Monday, May 05, 2008 8:10 PM
Subject: Re: [BUGS] Feature request


> Hello
>
> 2008/5/5  <Eugen(dot)Konkov(at)aldec(dot)com>:
> > So why I can do:
> > insert into (id) values ( default )
> > and can not do in my trigger:
> > new.id = default
> > Why?
>
> it's not possible - because you cannot mix PL/pgSQL statement
> (assignment) and SQL stetement.
>
> syntax of assignment
> :
> variable := expression
>
> expression is independent on variable, so there are not any "default"
> expression. PL/pgSQL and SQL are independent environments. If you need
> default values, simply don't change field.
>
> Regards
> Pavel Stehule