Re: What is the best way to merge two disjoint tables?

["Rodrigo De León" <rdeleonp@xxxxxxxxx>]

On 9/7/07, Chansup Byun <Chansup.Byun@xxxxxxx> wrote:
> One more question: Is there a way to make the  T2.U_ID + 1000  number to be incremental from a given number instead of adding 1000?

See here:
http://archives.postgresql.org/pgsql-sql/2007-05/msg00194.php

Then, say we want to start from 49:

SELECT   COALESCE(T1.U_USER, T2.U_USER) AS U_USER
       , COALESCE(T1.U_ID
                , CASE
                    WHEN T2.U_ID IS NOT NULL
                      THEN 48 + ROWNUM()
                  END
                 ) AS U_ID
    FROM TABLEA T1 FULL JOIN TABLEB T2 ON T1.U_USER = T2.U_USER
ORDER BY U_ID

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend