Re: SQL subquery to supply table name? - Mailing list pgsql-general

Scott Chapman wrote:
> I was lead to believe that Postgresql would handle this from reading the docs.
> This error message from psql made me think it would also:
>
> select txtcompanyname from (select table_quest from reviews where
> review_num=28) where review_num=28;
>
> ERROR:  sub-SELECT in FROM must have an alias
>         For example, FROM (SELECT ...) [AS] foo
>
> What is the "sub-SELECT in FROM" supposed to be used for if not this usage?
>

Read the error message again -- you just need an alias for the sub-select, e.g.:

select
   t.table_quest
from
   (select table_quest from reviews where review_num=28) AS t;
                                                        ^^^^^
                                                        ^^^^^

HTH,

Joe