Thread: SELECT syntax manual correction

SELECT syntax manual correction

From
Neil Zanella
Date:
Hello,

On page 147 of the postgres file reference.pdf the synopsis for the
SELECT statement is missing table aliases:

FROM from_item [, ...] ]

should read

FROM from_item [from_item_alias] [, ...]


Best Regards,

Neil


Re: SELECT syntax manual correction

From
Bruce Momjian
Date:
But from_item links to a section below which has a description for
aliases, right?

---------------------------------------------------------------------------

>
> Hello,
>
> On page 147 of the postgres file reference.pdf the synopsis for the
> SELECT statement is missing table aliases:
>
> FROM from_item [, ...] ]
>
> should read
>
> FROM from_item [from_item_alias] [, ...]
>
>
> Best Regards,
>
> Neil
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: SELECT syntax manual correction

From
Tom Lane
Date:
Neil Zanella <nzanella@cs.mun.ca> writes:
> On page 147 of the postgres file reference.pdf the synopsis for the
> SELECT statement is missing table aliases:
> FROM from_item [, ...] ]
> should read
> FROM from_item [from_item_alias] [, ...]

No, because aliases are included in the definition of from_item.

            regards, tom lane