Re: Column qualifier issue

On Mon, 12 Jan 2004, Tom Lane wrote:

> "Jim Wilson" <jimw(at)kelcomaine(dot)com> writes:
> > As far as I can tell, there isn't a way to get postgresql to accept column
> > qualifiers (e.g. tablenames). A 'parse error at or near "."' gets returned.
>
> You're either very confused or using a *very* old version of Postgres.
>
> What version is it, what query are you issuing exactly, and what exactly
> is the error message? (Cut-and-paste from a psql session would be the
> best way to answer the last two ... or if the query is being issued from
> another application, you could turn on query logging and send in an
> excerpt from the postmaster log.)

My guess from the rest of his message is something like:

sszabo=# insert into a (a.x) values ('3');
ERROR: syntax error at or near "." at character 17

(from my 7.5 machine).

However, AFAICS in sql92 the above isn't valid, because a.x doesn't meet
the syntactic requirements for elements in the column name list.