From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
---|---|
To: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Feature request |
Date: | 2008-05-05 17:26:38 |
Message-ID: | 002c01c8aed5$2d81fda0$1200a8c0@kharkov.localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-05-05 19:40:15 | Re: Feature request |
Previous Message | Pavel Stehule | 2008-05-05 17:10:00 | Re: Feature request |