SELECT syntax manual correction

Поиск
Список
Период
Сортировка
Искать

SELECT syntax manual correction

От:
Neil Zanella <nzanella@cs.mun.ca>
Дата:

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

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Neil Zanella  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
FAQ