Project

General

Profile

Actions
Copy link

Bug #4997

closed

PostgreSQL DISTINCT ON

Added by Andy Z almost 8 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Roel Standaert
Target version:
3.3.7
Start date:
06/27/2016
Due date:
% Done:

0%

Estimated time:

Description

Passes DISTINCT, but complains about DISTINCT ON:

"Wt: fatal error: ERROR: syntax error at or near ""ON"\"

LINE 1: ...t.id) SELECT DISTINCT ON (©.""location"") ©.""id"", ON (©....\"

in the query like following:

SELECT DISTINCT ON (©.location) © FROM client c ORDER BY ©.location;

Actions
Copy link
 #1

Updated by Koen Deforche almost 8 years ago

  • Status changed from New to InProgress
  • Assignee set to Roel Standaert
  • Target version set to 3.3.7
Actions
Copy link
 #2

Updated by Roel Standaert almost 8 years ago

  • Status changed from InProgress to Implemented @Emweb
Actions
Copy link
 #3

Updated by Koen Deforche over 7 years ago

  • Status changed from Implemented @Emweb to Resolved
Actions
Copy link
 #4

Updated by Roel Standaert about 7 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF