O$8.1 Select distinct on with postgres

[Jacques Zemron]

Hi Franco

 Here is my code
  Begin statement
           Sta: {Select distinct on ("FamRem")
  "FamRem","CodeMarque","Code" from "BIBLIOTHEQUE"}
           Sta: {Where "CodeMarque" like @[VARIABLES.CODE2]}
           Sta: {order by "FamRem"}
           End statement
  But the result is only the two first columns.

Cordialement,

Jacques ZEMRON




> Le 30 janv. 2018 à 17:30, Franco Maregotto <franco.maregotto at icloud.com> a écrit :
> 
> Works fine in my server.
> Can you write here an example (full statement) and specify what kind of data you want back?
> 
> Regards
> Franco
> 
> 
>> Il giorno 30 gen 2018, alle ore 16:22, Jacques Zemron <jacky at aec-ri.com> ha scritto:
>> 
>> Hi all,
>> 
>> I try tu use the "select distinct on" command on Posgresql 10 under Windows 10, The "select distinct" command work fine but the "select distinct on" doesn't work
>> 
>> 
>> Any Idea ?,
>> 
>> regards
>> 
>> Jacques ZEMRON
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com