Re: dynamic table/col names in plpgsql - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: dynamic table/col names in plpgsql
Date
Msg-id 20070626132426.GA14962@svana.org
Whole thread Raw
In response to dynamic table/col names in plpgsql  ("gary jefferson" <garyjefferson123@gmail.com>)
List pgsql-general
On Sat, Jun 23, 2007 at 09:43:01PM -0600, gary jefferson wrote:
> Is there a way to use a variable as the name of a table or column in
> plpgsql?

No, plpgsql is statically typed, it can't handle the possiblity of the
types of variables changing. Use a more dynamic
language(perl/tcl/python/etc...)

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: a JOIN on same table, but 'slided over'
Next
From: Rafal Pietrak
Date:
Subject: Re: a JOIN on same table, but 'slided over'