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
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,
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%TYPE)