Re: plpgsql, dynamic variable lengths.. - Mailing list pgsql-admin

From Tom Lane
Subject Re: plpgsql, dynamic variable lengths..
Date
Msg-id 31014.1581129363@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql, dynamic variable lengths..  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: plpgsql, dynamic variable lengths..  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> writes:
> Yes, but the issue is it won't always be three params, and not always the
> same variable in $1, $2, etc. It depends on which keys are present in the
> passed JSON object. Which I why I think I need to do something else like
> create a recordset and pass that in USING, or something. Just can't quite
> figure it out...

Maybe just pass the JSON object as the only USING param, and do the
field selections in the SQL fragments?

            regards, tom lane



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: plpgsql, dynamic variable lengths..
Next
From: Guillaume Lelarge
Date:
Subject: Re: plpgsql, dynamic variable lengths..