| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | sqllist <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Help on Union Query |
| Date: | 2000-10-24 22:06:41 |
| Message-ID: | 39F607F1.46CA4E47@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Mr. May,
The reason you're having trouble is that the problem you've described
does not call for a union query at all. What you want is a simple GROUP
BY query:
SELECT Node_ID, Word, Count(*)
FROM NodeIndex
GROUP BY Node_ID, Word
-Josh Berkus
--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 436-9166
for law firms, small businesses fax 436-0137
and non-profit organizations. pager 338-4078
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-24 22:51:03 | Re: knowing which columns have beend UPDATEd inside a TRIGGER? |
| Previous Message | Josh Berkus | 2000-10-24 22:05:25 | Re: help on createing table |