Обсуждение: relation_expr vs. qualified_name

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

relation_expr vs. qualified_name

От
Christopher Kings-Lynne
Дата:
How come half the ALTER TABLE statements use relation_expr and half use 
qualified_name?

Is one more correct now?

Chris



Re: relation_expr vs. qualified_name

От
Tom Lane
Дата:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> How come half the ALTER TABLE statements use relation_expr and half use 
> qualified_name?

relation_expr allows specification of "foo *" and "ONLY foo", and is
appropriate for ALTER commands that can recurse to child tables.
qualified_name is appropriate for the ones that are inherently
nonrecursive.

I'm entirely prepared to believe that some of them are misclassified in
the grammar ... you see any problems?
        regards, tom lane