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.stehule@gmail.com>
To: <Eugen.Konkov@aldec.com>
Cc: <pgsql-bugs@postgresql.org>
Sent: Monday, May 05, 2008 8:10 PM
Subject: Re: [BUGS] Feature request
> Hello
>
> 2008/5/5 <Eugen.Konkov@aldec.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