In > 7.3 you can also
CREATE OR REPLACE FUNCTION xxx() RETURNS TRIGGER AS'
BEGIN
END'LANGUAGE plpgsql;
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
>
> I'm trying to create a trigger to enforce a constraint onto two
possible
> foreign tables
> my function is defined as:
>
> <-- snip -->
> CREATE OR REPLACE FUNCTION
> sp_check_tranitem_productid(tbl_tranitem.fld_tranitem_id%TYPE,
> tbl_tranitem.fld_tranitem_type%TY
Title: "function has no parameter $1" - help.
I'm trying to create a trigger to enforce a constraint onto two possible foreign tables
my function is defined as:
<-- snip -->
CREATE OR REPLACE FUNCTION sp_check_tranitem_productid(tbl_tranitem.fld_tranitem_id%TYPE,