1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • Re: ORDER BY in UNION in postgres 7.3.9

    From paedru fernando@21:1/5 to Robert Welz on Mon Aug 22 22:45:22 2022
    On Tuesday, August 5, 2008 at 4:18:48 PM UTC+5:30, Robert Welz wrote:
    Laurenz Albe <inv...@spam.to.invalid> wrote:
    ...

    SELECT * FROM (SELECT * FROM a UNION SELECT * FROM b) dummy
    ORDER BY upper(val);

    id | val
    ----+-------------
    1 | one
    1 | ONE HUNDRED
    2 | two
    2 | TWO HUNDRED
    (4 rows)

    There you go!

    Yours,
    Laurenz Albe
    Great! Thank you very much!
    Robert
    ...........................................


    Great solution!! Thanks - Laurenz Albe . IF you ever be to India (Tamilnadu). your beer's on me.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)