Re: Dynamically access to field on a RECORD variable

If it's not possible, can I create a function that gets a RECORD and a
tablename and returns the correct value. For example:

CREATE FUNCTION my_value(TEXT, RECORD) RETURNS TEXT AS '
  DECLARE
    table_name ALIAS FOR $1
    rec ALIAS FOR $2
  BEGIN
    IF (table_name = 'my_table1') THEN
      RETURN rec.my1_field;
    ELSIF (table_name = 'my_table2') THEN
      RETURN rec.my2.field;
    ...
  END;
' LANGUAGE plpgsql;

Em Ter, 2005-05-03 às 11:52, Tom Lane escreveu:
> Ricardo Vaz Mannrich <rvm_l1@silcom.com.br> writes:
> > Is it possible?
>
> Not in plpgsql.  I believe you could do it in any of the other PLs though.
>
>             regards, tom lane
--
Ricardo Vaz Mannrich <rvm_l1@silcom.com.br>