Nice work-around Marc. Thank you !
On 6 February 2015 at 13:01, Marc Mamin <M.Mamin@intershop.de> wrote:
>
>>Von: pgsql-general-owner@postgresql.org
>> [pgsql-general-owner@postgresql.org]" im Auftrag von "David Johnston
>> [david.g.johnston@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+postgres@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;