select distinct

Hi,

I am running this query and expecting distinct results

ebmh=> SELECT DISTINCT articles.id FROM articles, paragraphs WHERE
paragraphs.ar
ticle_key = articles.id and paragraphs.paragraph ~* 'dementia' ORDER BY
articles
.page_no;
id
--
4
4
4
4
16
12
12
12
12
12
3
3
3
(13 rows)

however, if i remove the ORDER BY, it works

ebmh=> SELECT DISTINCT articles.id FROM articles, paragraphs WHERE
paragraphs.ar
ticle_key = articles.id and paragraphs.paragraph ~* 'dementia';
id
--
3
4
12
16
(4 rows)

this is in 6.4 and 6.5.2, am i doing something wrong?

Cheers

Tim Joyce
Chief Enthusiast
tim(at)hoop(dot)co(dot)uk
HOOP Ltd
http://www.hoop.co.uk
01202 251 816

HOOP is proud to be a member of the Paneris community (www.paneris.co.uk)