Computed table name in function - Mailing list pgsql-sql

From Ray Madigan
Subject Computed table name in function
Date
Msg-id IIEPJABILGOCODDLDNJFOEEFCCAA.ray@madigans.org
Whole thread Raw
Responses Re: Computed table name in function
List pgsql-sql
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 = ?;


Thanks



pgsql-sql by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: finding unused indexes?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Computed table name in function