by pavel.stehule@[EMAIL PROTECTED]
("Pavel Stehule")
May 5, 2008 at 07:10 PM
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
