Re: [HACKERS] FETCH without FROM/IN

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: [HACKERS] FETCH without FROM/IN
Дата
Msg-id 20000112175326.A2376@fam-meskes.de
обсуждение исходный текст
Ответ на Re: [HACKERS] FETCH without FROM/IN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] FETCH without FROM/IN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Jan 12, 2000 at 11:09:11AM -0500, Tom Lane wrote:
> It looks to me like the backend grammar *does* accept FETCH without
> IN/FROM cursor.  Which seems pretty bizarre --- I don't understand how
> it makes sense to omit a cursor name from FETCH.

Yes, it does accept if NO portal name is given. This is corrected by the
patch. But what I wanted to talk about is the IN/FROM keyword. 

>          <fetch statement> ::=
>               FETCH [ [ <fetch orientation> ] FROM ]
>                 <cursor name> INTO <fetch target list>

To me this seems to say that FROM is just optional. Okay, if I make it
optional in our parser?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Robinson
Дата:
Сообщение: Copy from/to asymmetry
Следующее
От: Hideyuki Kawashima
Дата:
Сообщение: ...