2012/3/30 Richard Huxton <dev@xxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]
|
|