Project

General

Profile

Actions

Bug #4997

closed

PostgreSQL DISTINCT ON

Added by Andy Z over 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Roel Standaert
Target version:
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 #1

Updated by Koen Deforche over 8 years ago

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

Updated by Roel Standaert over 8 years ago

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

Updated by Koen Deforche about 8 years ago

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

Updated by Roel Standaert over 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF