Help on Union Query

Hi,

I have an Index table with the following structure:

| Node_ID (int) | Word (varchar)|

and attempting to perform a query that returns the distinct Node_ID for
an occurence of [word] in addition to a count of that [word] within the
Node_ID.

Here is the query I have atm:

select distinct on (Node_ID) Node_ID from NodeIndex where word='[a word]' union
select count(*) from NodeIndex where Node_ID in (select distinct on (Node_ID)
Node_ID from NodeIndex where word='[a word]') order by count;

Any assistance would be appreciated.
Craig May

Enth Dimension
http://www.enthdimension.com.au