2012/3/30 Richard Huxton <d...@archonet.com>: > On 29/03/12 23:28, Pavel Stehule wrote: >> >> select anum from t1 where anum = 4 >> union all select 100 limit 1; > > > I'm not sure the ordering here is guaranteed by the standard though, is it? > You could end up with the 4 being discarded.
A order is random for only "UNION", "UNION ALL" should to respect order. But I didn't check it in standard. Pavel > > -- > Richard Huxton > Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
