From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | twanger(at)eudoramail(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org, bertheau(at)bab24(dot)de |
Subject: | Re: select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1 |
Date: | 2001-06-22 13:54:27 |
Message-ID: | 3360.993218067@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
"Markus Bertheau" <twanger(at)eudoramail(dot)com> writes:
> Then i tried
> select partners.person_id, count(views.person_id) from partners, views where views.person_id = partners.person_id group by views.person_id
> but this gave very strange results which are definitely not what i wanted.
I think you mistyped, because that query will also fail:
regression=# create table views (person_id int, timestamp timestamp);
CREATE
regression=# create table partners (person_id int UNIQUE, domain text);
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'partners_person_id_key' for table 'partners'
CREATE
regression=# select partners.person_id, count(views.person_id)
regression-# from partners, views where views.person_id = partners.person_id
regression-# group by views.person_id;
ERROR: Attribute partners.person_id must be GROUPed or used in an aggregate function
How about showing us what you *really* did?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-22 14:22:32 | Re: Re: Re: binary data |
Previous Message | Ari Nepon | 2001-06-22 13:43:58 | RE: Help with a double left join |