How come half the ALTER TABLE statements use relation_expr and half use 
qualified_name?

Is one more correct now?

Chris


Thu, 18 Mar 2004 11:06:10 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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

Wed, 17 Mar 2004 22:42:39 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: relation_expr vs. qualified_name 