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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <pgsql-bugs@postgresql.org>
Sent: Monday, May 05, 2008 8:10 PM
Subject: Re: [BUGS] Feature request
Hello
2008/5/5 <[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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
