Re: [GENERAL] joinning tables

2001-09-14 Thread Stephan Szabo 

On Wed, 12 Sep 2001, Emmanuel SARACCO wrote:

 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.

Can you give an example of what you're seeing?


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] joinning tables

2001-09-14 Thread Jeff Eckermann 

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 [EMAIL PROTECTED] wrote in message
9nnjc3$68p$[EMAIL PROTECTED]">news:9nnjc3$68p$[EMAIL PROTECTED]...
 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



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]