| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Mitch Vincent" <mitch(at)venux(dot)net> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] New count() question |
| Date: | 1999-12-19 22:38:56 |
| Message-ID: | 10010.945643136@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Mitch Vincent" <mitch(at)venux(dot)net> writes:
> select count (*) as total from applicants as a,applicants_states as
> s,resume_search as re where a.app_id=s.app_id and a.app_id=re.app_id and
> re.user_id=291
> That's all well and fine except that it only counts the total from the
> applicants table, not the total from the rest of the query.
Er ... um ... what? The above will generate the count of the number of
joined tuples satisfying the WHERE condition. There is no "rest of the
query". I'm not following what you actually want to do, but evidently
this isn't it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-12-19 22:52:20 | Re: [SQL] Rule Question |
| Previous Message | Mitch Vincent | 1999-12-19 21:40:37 | Rule Question |