well. i had some free time to search it. from here:http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-UNION
see the default is indeed UNION DISTINCT. so changing it to UNION ALL
you'll get different results - are they the ones you're expecting?
On Wed, Mar 12, 2014 at 9:36 AM, Stephen Sprague <[EMAIL PROTECTED]> wrote: