Tim Smith-2 wrote > 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 ? I suspect that the main issue you are encountering is that "FROM v_row" is complaining that v_row is not a known relation. You really need to provide error messages or your observations in situations like this. A blanket "does not seem to work" is not enough when asking others to identify what you are doing wrong. A self-contained example is even better. If the above is true then this has nothing with row_to_json other than that is the function you choose to try and use. A simple "SELECT * FROM v_row" would get you the same error. David J. -- View this message in context: http://postgresql.nabble.com/Using-row-to-json-with-ROWTYPE-tp5836841p5836848.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
