Dynamically access to field on a RECORD variable - Mailing list pgsql-general

From Ricardo Vaz Mannrich
Subject Dynamically access to field on a RECORD variable
Date
Msg-id 1115129042.25781.16.camel@curitiba.silcom
Whole thread Raw
Responses Re: Dynamically access to field on a RECORD variable
Re: Dynamically access to field on a RECORD variable
Postgresql 8.0.3 Zip Files corrupt...
List pgsql-general
Supose I have this function

CREATE OR REPLACE my_func(TEXT) RETURNS text AS '
  DECLARE
    var_name ALIAS FOR $1;
    rec RECORD;
  BEGIN
    SELECT * INTO rec FROM my_table WHERE my_key = 1;
    -- Here is my problem
    RETURN rec.var_name;
  END;
' LANGUAGE plpgsql;

SELECT my_func('my_field');

I want the return row in the function executes as:

RETURN rec.my_field;

Is it possible?

Thank you.

--
Ricardo Vaz Mannrich <rvm_l1@silcom.com.br>


pgsql-general by date:

Previous
From: Alexandre Biancalana
Date:
Subject: postgresql 8 abort with signal 10
Next
From: Pavel Stehule
Date:
Subject: Re: some questions : psql