Here's what I thought to be an odd result from the 7.0beta3 parser...

create table foo (id serial, h_count integer);
insert into foo (h_count) values (10);
create table temp_foo as select * from foo;    
drop table foo;
drop sequence foo_id_seq;
create table foo (id serial, h_count integer);
insert into foo (id, h_count) select t.id, t.count from temp_foo t;

ERROR:  Attribute t.id must be GROUPed or used in an aggregate function

I mislabeled the 't.h_count' column in my INSERT statement as 't.count',
and what I found strange was that the parser evidently thinks t.count is
an aggregate.  Is 't.count' valid use/syntax for an aggregate?

Regards,
Ed Loehr

Thu, 25 May 2000 10:40:19 -0500
Ed Loehr <eloehr@austin.rr.com>
parser oddity (t.count)
Ed Loehr <eloehr@austin.rr.com> writes:
> insert into foo (id, h_count) select t.id, t.count from temp_foo t;

> ERROR:  Attribute t.id must be GROUPed or used in an aggregate function

> I mislabeled the 't.h_count' column in my INSERT statement as 't.count',
> and what I found strange was that the parser evidently thinks t.count is
> an aggregate.  Is 't.count' valid use/syntax for an aggregate?

Hmm.  Due to some ancient Postquel features that you probably don't want
to hear about, foo.bar and bar(foo) are considered near-equivalent
notations by the parser.  It looks like when it couldn't find 'count' as
a field name, it tried and succeeded to interpret it as a function call
instead.

(A contributing problem here is that the parser is absolutely lax about
what it will take as the argument of count().  IMHO you should have
gotten something like "Unable to select an aggregate function
count(unknown)", which might have been a little less confusing.)

It works in the other direction too: field(foo) will be interpreted as
foo.field if foo has a column named field.

This equivalence can be pretty confusing if you don't know about it, but
I'm hesitant to suggest ripping it out because of the risk of breaking
old applications.  Anyone have strong opinions one way or the other?

			regards, tom lane

Thu, 25 May 2000 12:28:40 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: parser oddity (t.count) 

> to hear about, foo.bar and bar(foo) are considered near-equivalent
> notations by the parser.  It looks like when it couldn't find 'count' as
> a field name, it tried and succeeded to interpret it as a function call
> instead.
> 

> It works in the other direction too: field(foo) will be interpreted as
> foo.field if foo has a column named field.
> 
> This equivalence can be pretty confusing if you don't know about it, but
> I'm hesitant to suggest ripping it out because of the risk of breaking
> old applications.  Anyone have strong opinions one way or the other?

This feature is sacrosanct for me, if you ripp it, you take away the
feature to add calculated columns to tables.

The important part for me, is that foo.calcit calls the function calcit(foo).

Andreas

Fri, 26 May 2000 08:27:40 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
Re: parser oddity (t.count)