Re: Column qualifier issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Column qualifier issue
Date
Msg-id 7998.1073969787@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column qualifier issue  ("Jim Wilson" <jimw@kelcomaine.com>)
List pgsql-general
"Jim Wilson" <jimw@kelcomaine.com> writes:
> Yes, I think you are correct on that.  I was misreading column reference for
> column name.  Would it be difficult to patch my local copy to either permit
> this or strip off the characters from the qualifier portion in the parser?

[shrug...]  You could probably hack the grammar to throw away a
qualifier there, but wouldn't it be easier to fix your incorrect SQL?

AFAICS, SQL92 does not allow a qualified name there, and SQL99 does but
appears to assign it some completely other semantics than what you're
expecting --- looks like an object method call of some kind... so you
are in for trouble in the long run if you don't fix your code.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum Error
Next
From: Greg Stark
Date:
Subject: Re: Drawbacks of using BYTEA for PK?