| From: | "Jeff Eckermann" <jeckermann(at)verio(dot)net> |
|---|---|
| To: | <esaracco(at)aspasia(dot)fr> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: joinning tables |
| Date: | 2001-09-14 21:33:27 |
| Message-ID: | 02e701c13d64$ec417020$279c10ac@INTERNAL |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)saracco(at)d-interactive(dot)com> wrote in message
news:9nnjc3$68p$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Hallstrom | 2001-09-14 21:35:45 | Re: get certain # of recs |
| Previous Message | Jeff Eckermann | 2001-09-14 21:27:50 | Re: Case sensitivity issue |