Thread: relation_expr vs. qualified_name

relation_expr vs. qualified_name

From
Christopher Kings-Lynne
Date:
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

From
Tom Lane
Date:
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