Using row_to_json with %ROWTYPE ?

Поиск
Список
Период
Сортировка
От Tim Smith
Тема Using row_to_json with %ROWTYPE ?
Дата
Msg-id CA+HuS5EbRgf49KBhBjF5hgT7-GEn7S-GeAkLks7xkzMqCCOfzA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using row_to_json with %ROWTYPE ?
Re: Using row_to_json with %ROWTYPE ?
Список pgsql-general
Hi,

I have a function that broadly looks like this :

create function doStuff() returns json as $$
DECLARE
v_row my_view%ROWTYPE;
BEGIN
select * into strict v_row from my_view where foo=bar;
select row_to_json(v_row) from v_row;
END;
$$ LANGUAGE plpgsql;


However this does not seem to work ?   What am I doing wrong ?

Thanks

Tim


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