Re: plpgsql, dynamic variable lengths..

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: plpgsql, dynamic variable lengths..
Дата
Msg-id CAECtzeWwRbMV5eXSdyt+SnDD_VhN6vdiRkjpbHjSq0Lg_N16qg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpgsql, dynamic variable lengths..  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: plpgsql, dynamic variable lengths..
Список pgsql-admin
Le sam. 8 févr. 2020 à 03:36, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
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?


And why don't you do this instead?

SQLSTRING := SQLSTRING || ' AND col1 = ' || quote_literal(args->>'col1');


--
Guillaume.

В списке pgsql-admin по дате отправления:

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