Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Feature request
- 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
- Subject: Re: Feature request
- Date: Mon, 5 May 2008 19:10:00 +0200
- Message-id: <162867790805051010o1ab6b981wff1529517680e4f2(at)mail(dot)gmail(dot)com>
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
- Follow-Ups:
- Re: Feature request
- From: Eugen.Konkov
- Re: Feature request
- References:
- Feature request
- From: Eugen.Konkov
- Feature request
- Prev by Date: Feature request
- Next by Date: Re: Feature request
- Previous by thread: Feature request
- Next by thread: Re: Feature request
- Indexes: