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.stehule@[EMAIL PROTECTED]
>
To: <Eugen.Konkov@[EMAIL PROTECTED]
>
Cc: <pgsql-bugs@[EMAIL PROTECTED]
>
Sent: Monday, May 05, 2008 8:10 PM
Subject: Re: [BUGS] Feature request


> Hello
>
> 2008/5/5  <Eugen.Konkov@[EMAIL PROTECTED]
>:
>> 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 


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs