Re: Feature request

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