Re: joinning tables - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: joinning tables
Date
Msg-id 02e701c13d64$ec417020$279c10ac@INTERNAL
Whole thread Raw
In response to joinning tables  ("Emmanuel SARACCO" <emmanuel.saracco@d-interactive.com>)
List pgsql-general
Outer joins are supported in PostgreSQL, but not before version 7.1.
If you are using version 7.1, please post your failing query, and someone
will be able to help you.

"Emmanuel SARACCO" <emmanuel.saracco@d-interactive.com> wrote in message
news:9nnjc3$68p$1@news.tht.net...
> hi,
>
> it seems like postgresql does not interpret a LEFT JOIN instruction like
> other sql engines. for exemple, if it have some null values on keys, data
> tables are not joinned... same has if it was a INNER JOIN instruction.
>
> any idea?
>
> thanks



pgsql-general by date:

Previous
From:
Date:
Subject: Re: How to implement transaction in plpgsql?
Next
From: Peter Eisentraut
Date:
Subject: Re: Numerical DB/Table Names