On Wednesday, May 11, 2011 11:01:56 AM Andreas Joseph Krogh wrote: > På onsdag 11. mai 2011 kl 10:56:19 skrev <t...@fuzzy.cz>: > > > CREATE TRIGGER trig_x_bool BEFORE INSERT ON x FOR EACH ROW EXECUTE > > > PROCEDURE > > > trigger_x(true); > > The docs clearly state what the valid values are and the literal 'true' > > is not one of them (TRUE is). See this: > > > > http://www.postgresql.org/docs/9.0/interactive/datatype-boolean.html > > What are you trying to accomplish? "CREATE OR REPLACE FUNCTION trigger_x()" > does not declare any formal-parameters, so calling it with arguments > doesn't make sense. I'm surprised creating the other triggers didn't > produce an error stating "No function defined with the name trigger_ix and > the given argument-type". Read the docs. Parameters for triggers are not passed as normal function parameters. Thats why you access them via via TG_ARGV in plpgsql.
The grammar accepts only a very limited amount of parameters there: -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
