| From: | "James Cooper" <jim(at)luckydigital(dot)com> |
|---|---|
| To: | "sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | a change of query |
| Date: | 2003-02-25 22:03:35 |
| Message-ID: | 004a01c2dd19$be6fe400$c900a8c0@jax |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
select distinct cp.person_id from cluster_person cp, cluster c where cp.cluster_id = c.cluster_id and c.c_id = 1
can this query be changed to give just the row count?( of the distinct rows )
yes: i am aware of count() but this wont count the distinct rows - I can however achive this with an nested person_id in(select... etc but that slows things down big time!!!!
the above quey gives me my resultset asap - is there a way to get just the number of rows with the same speed
My thoughts are that I could just make a plpgsql function with a GET Diagniostics ROW_COUNT -
thoughts?
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Hilton | 2003-02-25 22:39:17 | Re: a change of query |
| Previous Message | Tom Lane | 2003-02-25 21:10:14 | Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 |