relation_expr vs. qualified_name
Started by Christopher Kings-Lynnealmost 22 years ago2 messages
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
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