Re: [GENERAL] converting Informix outer to Postgres

[H.J. Sanders]

Hi.

>From some documentation:

In INFORMIX SQL, outer tables are defined in the FROM clause with the OUTER 
keyword :

    SELECT ... FROM a, OUTER(b)
     WHERE a.key = b.akey

    SELECT ... FROM a, OUTER(b,OUTER(c))
     WHERE a.key = b.akey
       AND b.key1 = c.bkey1
       AND b.key2 = c.bkey2 

PostgreSQL 7.1 supports the ANSI outer join syntax :

    SELECT ... FROM cust LEFT OUTER JOIN order
                         ON cust.key = order.custno

    SELECT ...
      FROM cust LEFT OUTER JOIN order
                     LEFT OUTER JOIN item
                     ON order.key = item.ordno
                ON cust.key = order.custno
     WHERE order.cdate > current date







Any help?

Henk


> -----Oorspronkelijk bericht-----
> Van: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Martijn van Oosterhout
> Verzonden: woensdag 8 november 2006 11:42
> Aan: [EMAIL PROTECTED]
> CC: pgsql-general@postgresql.org
> Onderwerp: Re: [GENERAL] converting Informix outer to Postgres
> 
> 
> On Tue, Nov 07, 2006 at 06:35:05PM -0500, [EMAIL PROTECTED] wrote:
> > Hi all,
> > I have been working on this Informix SQL query which has an outer join.
> > I have attached Informix query and my "supposedly" solution to this query
> > but I cannot get the same count. I appreciate for any help.
> > Thanks.
> 
> I don't know what the Informix outer join is, but is it like the SQL
> FULL OUTER JOIN? Have you tried using that?
> 
> Have a nice day,
> -- 
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to 
> > litigate.
> 

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings