Postgres Pro
Downloads
Home   >   mailing lists

Re: PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query
Date
Msg-id dcc563d10905041210n69abf891q3b0eeab63336f4ff@mail.gmail.com
Whole thread Raw
In response to PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query  (DaNieL <daniele.pignedoli@gmail.com>)
List pgsql-general
Tree view 
To get a postgresql behavior similar to mysql's you need to use distinct on:

select distinct on (a) a,b,c from sometable; (or something like that)

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query
Next
From: Jeff Davis
Date:
Subject: Re: PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query