Re: Stored Procedure table/column args

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.klaver@gmail.com