DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=LCe6EbwLejRicJT2i1s4Q+PeYU/dX+gkVak9Zu8Qp5fRB5ev1fQCbH809xLQ+R44zYcM5zMdWuGjcu2V4b4K3fYR+OmuLTHDeCuw3gOFM1rB1m7k2KfI0J/NMqITQ43UrAgBI4qNQBSQ9cAOHPoLouPYl4vDlE6C6JqxPVi3iiI=
Message-ID: <dcc563d10710101110i1be5fe9u84171818065d370f@mail.gmail.com>
Date: Wed, 10 Oct 2007 13:10:02 -0500
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Ray Madigan" <ray@madigans.org>
Subject: Re: Computed table name in function
Cc: Pgsql-Sql <pgsql-sql@postgresql.org>
In-Reply-To: <IIEPJABILGOCODDLDNJFOEEFCCAA.ray@madigans.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <IIEPJABILGOCODDLDNJFOEEFCCAA.ray@madigans.org>

On 10/10/07, Ray Madigan <ray@madigans.org> wrote:
> I have a problem that I don't know where to look to understand the problem.
>
> I have a function that I first select to get a table name followed by
> another select into on that table name.  If someone could tell me where to
> look to solve this problem I would appreciate it.
>
> It is something like
>
> DECLARE rec1 Record;
>         rec2 Record;
>
> SELECT aName INTO rec1 FROM tableA WHERE new.xxx = ?;
>
> IF FOUND THEN
>
>     SELECT * INTO rec2 FROM rec1.aName where new.xxx = ?;

You have to build your query as a string then use execute on it.