Postgres Pro
Downloads
Home   >   mailing lists

Select Distinct Order By Array_Position - Mailing list pgsql-sql

From Mark Williams
Subject Select Distinct Order By Array_Position
Date
Msg-id 004301d485bc$00347250$009d56f0$@gmail.com
Whole thread Raw
Responses Re: Select Distinct Order By Array_Position
Re: Select Distinct Order By Array_Position
List pgsql-sql
Tree view

Hi,

 

I am getting an error “SELECT DISTINCT, ORDER BY expressions must appear in select list”. I am ordering by documents.id and it appears in my select list. So I am guessing the problem lies with the array. Is there any way of achieving this? Query is below.

 

SELECT DISTINCT documents.id, page_no FROM texts LEFT JOIN documents on documents.id=texts.doc_id WHERE doc_id IN (26194, 2345, 189) AND  (text LIKE '%RIVER%') ORDER BY array_position(ARRAY[26194, 2345, 189]::INTEGER[], documents.id)

 

Thanks,

 

Mark

__

 

pgsql-sql by date:

Previous
From: "Voillequin, Jean-Marc"
Date:
Subject: Weird "could not determine which collation to use for stringcomparison" with LEAST/GREATEST on PG11 procedure
Next
From: Rob Sargent
Date:
Subject: Re: Select Distinct Order By Array_Position