'psuedo
Can you create stored procedures that are built from parameters as
below, or does this defeat the pre-compiled purpose of an SP?
create function item_exists (tbl character varying, col character
varying, col_val character varying)
DECLARE
x integer;
PERFORM col FROM tbl
WHERE col="'" + col_val + "'"
IF FOUND THEN
x := 1;
else
x := 0;
end if;
RETURN x;
....
left out some syntax, but should deliver the idea
trying to build build a generic "check for existing", that's not
specific to a specific table/column without returning recordset
object overhead
any better ways
thanks