Re: ++ PLPGSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ++ PLPGSQL
Date: 2005-03-23 11:24:17
Message-ID: 424151E1.9010902@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • ++ PLPGSQL at 2005-03-23 09:22:23 from Shaun Clements

Browse pgsql-general by date

  From Date Subject
Next Message Walker, Jed S 2005-03-23 11:25:21 PostgreSQL support
Previous Message Sean Davis 2005-03-23 11:13:47 Re: Question about function body checking and 8.1