Re: SQL subquery to supply table name?

On Thu, 26 Sep 2002, Scott Chapman wrote:

> Here's the details:
> Table "reviews"
> Column | Type | Modifiers
> ---------------------------------+---------+----------------------------------------
> review_num | integer | default
> nextval('review_number'::text)
> table_quest | text |
>
>
> Table "mpe_quest"
> Column | Type | Modifiers
> ------------------------+---------+-----------
> review_num | integer |
> txtcompanyname | text |
>
>
> select foo.txtcompanyname from (select table_quest from reviews where
> review_num=28) as foo where review_num=28;
> It comes back and says No such attribute or function foo.txtcompanyname.

Yep, foo has a table_quest column. In 7.3 (now in beta) you probably
could make a function that returns a rowset from the table given as
its argument.