> > Interestingly - & i'm curious as to why" > > SELECT '1' UNION SELECT 2; > ?column? > ---------- > 1 > 2 > (2 rows) > > SELECT '1' UNION SELECT 1; > ?column? > ---------- > 1 > (1 row) > > > I didn't think UNION did an explicit "distinct" - if that is what is > happening? >
UNION removes duplicates. UNION ALL does not. James -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
