UNION & LIMIT & ORDER BY - Mailing list pgsql-sql

Hi

Why this query doesn't work ?

<<
SELECT  '1' AS id 
FROM  users
ORDER BY id
LIMIT 1
UNION
SELECT  '2' AS id 
FROM  users
>>

And this one work ?

<<
SELECT  '1' AS id 
FROM  users
UNION
SELECT  '2' AS id 
FROM  users
ORDER BY id
LIMIT 1
>>

-- 
-------------------------------------------------------------------------
| Dans le cours d'un long gouvernement, on va au mal par une pente      |
| insensible, et ne remonte au bien que par un effort.                  |
|                       Montesquieu, "de l'esprit des lois" livre V/VII |
-------------------------------------------------------------------------
Emmanuel Engelhart alias Kelson | ICQ UIN : 53388731 | TEL 01.58.46.04.79