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
