Re: dynamic table naming in function - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: dynamic table naming in function
Date
Msg-id 20051029181408.GA14086@wolff.to
Whole thread Raw
In response to dynamic table naming in function  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
On Sat, Oct 29, 2005 at 10:45:21 -0700,
  Matthew Peter <survivedsushi@yahoo.com> wrote:
> Out of curiosity, I was wondering if it is possible to
> use dynamic table names in a function? AND whether or
> not you can test a value prior to insert to see
> whether or not you want to update that column. Where
> you could pass in the name of the table for it use ANY
> name passed in rather than statically defining it.

You can use the EXECUTE statement to do this kind of thing.

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: dynamic table naming in function
Next
From: Tom Lane
Date:
Subject: Re: dynamic table naming in function