Re: ++ PLPGSQL - Mailing list pgsql-general

From Richard Huxton
Subject Re: ++ PLPGSQL
Date
Msg-id 424151E1.9010902@archonet.com
Whole thread Raw
In response to ++ PLPGSQL  (Shaun Clements <ShaunC@relyant.co.za>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: Question about function body checking and 8.1
Next
From: "Walker, Jed S"
Date:
Subject: PostgreSQL support