>Von: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]" >im Auftrag von "David Johnston [david.g.johns...@gmail.com] >Gesendet: Freitag, 6. Februar 2015 00:38 >An: Tim Smith >Cc: Adrian Klaver; pgsql-general >Betreff: Re: [GENERAL] Using row_to_json with %ROWTYPE ? >On Thu, Feb 5, 2015 at 4:29 PM, Tim Smith <randomdev4+postg...@gmail.com> >wrote: > > You're most welcome to look at my view definition view if you don't > believe me .... > > View definition: > SELECT a.session_id, > a.session_ip, > a.session_user_agent, > a.session_start, > a.session_lastactive, > b.user_id, > b.tenant_id, > b.reseller_id, > b.tenant_name, > b.user_fname, > b.user_lname, > b.user_email, > b.user_phone, > b.user_seed, > b.user_passwd, > b.user_lastupdate, > b.tenant_lastupdate > FROM app_sessions a, > app_users_vw b > WHERE a.user_id = b.user_id; > >?So that view and definition are correct. >So either PostgreSQL is seeing a different view (in a different schema) or the >function is confused in ways difficult to predict. >I guess it is possible that: >(SELECT v_?row FROM v_row) would give that message but I get a "relation v_row >does not exist" error when trying to replicate the scenario. >?It may even be a bug but since you have not provided a self-contained test >case, nor the version of PostgreSQL, the assumption is user error.? >David J.
Hello, I don't know if there is some internal confusion when using the ROWTYPE (bug?) but if this helps, following function is equivalent and does the job: create or replace function doStuff() returns json as $$ select row_to_json(app_val_session_vw) from app_val_session_vw WHERE ...; $$ LANGUAGE sql;
