Re: plpgsql, dynamic variable lengths..

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql, dynamic variable lengths..
Дата
Msg-id 31014.1581129363@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql, dynamic variable lengths..  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: plpgsql, dynamic variable lengths..  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: plpgsql, dynamic variable lengths..
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: plpgsql, dynamic variable lengths..