Thread: ++ PLPGSQL

Adding to that.

Can you assign the value of a dynamic record value.
For example

If I have written dataset returned, into a record.
I now want to call on a particular column value from the first row.
The column name is dynamic.
Can I use something like this

sales_month1_x := RECORDNAME.quote_ident('month1_'||quote_literal(yr2));

Where the value of
RECORDNAME.month1_2004
is assigned to sales_month1_x

Is this possible.
It doesnt look right, in that I have referenced RECORDNAME.quote_ident
That should bomb out..
how would I reference the dynamic column of the record.

Thanks in advance.

Kind Regards,
Shaun Clements

Shaun Clements wrote:
> Can you assign the value of a dynamic record value.
> For example
> sales_month1_x := RECORDNAME.quote_ident('month1_'||quote_literal(yr2));

You're right - it won't work. PLPGSQL has strict type-checking, so it's
no good for this sort of stuff. Perhaps pl/tcl/perl/python would be
better for you.

--
   Richard Huxton
   Archonet Ltd