[Pgsql-ayuda] Full outer join

[Martin Marques]

El Lun 22 Dic 2003 10:14, jtaaribi escribi=F3:
>
>  La consulta ser=EDa:
>
>   select t1.num, t1.col1, t2.col3
>   from t1 full outer join t2 on
>        t1.num =3D t2.num and
>        t1.col2 =3D 1 and
>        t2.col4 =3D 5
>
>  Para obtener:
>
>   num | col1 | col3
>  -----+------------
>     1 |  a   | xxx
>     2 |  b   | null
>     5 | null | zzz
>
>  Pero se produce un error: "FULL JOIN is only supported with mergejoinable
> join conditions"

   select t.num, t.col1, t.col3
   from (SELECT t1.num,t1.col1, t2.col3 FROM
	t1 full outer join t2 on
        t1.num =3D t2.num)
   WHERE=20
        t1.col2 =3D 1 and
        t2.col4 =3D 5


=2D-=20
 10:49:01 up 26 days, 17:05,  4 users,  load average: 0.15, 0.37, 0.53
=2D----------------------------------------------------------------
Mart=EDn Marqu=E9s        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
=2D----------------------------------------------------------------