Re: [GENERAL] Stored Procedure table/column args

[Adrian Klaver]

On 09/02/2013 06:06 PM, Bret Stern wrote:

'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

http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

thanks

--
Adrian Klaver
adrian.kla...@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general