Re: Referring to derived column name in a RECORD

David B wrote:
>   SELECT to_char( created_timestamp, 'DDMMYY' ) AS "joined_on",

>     r_app.joined_on ; -- HOW do I reference this value?...this does not work

Try either making that first line:
   ... AS joined_on,

(i.e. without the double quotes) or make the second one:
   r_app."joined_on";

(i.e. with double quotes)

HTH,

Joe