postgresql jointype outer

[msca]

Hi,

I would like to use outer joins with postgresql database.
I put joinType="outer" in <field>.


Like this:

		<field includeFrom="stus.stus_full_name" title="Created by" width="150" />
		<field name="st_cid" type="integer" foreignKey="stus.stus_id" joinType="outer" hidden="true" />

The result is:

SQLDriver - [builtinApplication.dc_1_overview_20_dcit_fetch] The relation between dc_1_overview_20_dcit and stus is defined as an outer join, but outer joins are not yet supported on this database product (postgresql)  Falling back to a regular inner join.

Is there a way to use outer (left) joins with postgresql?
Will it be implemented in smartgwt, or we have to look a workaround?

Thank you in advance,
Szabi

[Isomorphic]

That message is a bit out of date, but the joinType documentation does point out that you have to use ANSI-style joins if you want to support outer joins with databases other than Oracle or SQL Server.

[msca]

postgresql jointype outer

Hi,

Thank you for answer.

I could make it use join, but i would like to use LEFT join.

The sql like this:

... stus.stus_full_name FROM scci JOIN stus ON scci.st_mid = stus.stus_id WHERE ('1'='1')

But i need this:

... stus.stus_full_name FROM scci LEFT JOIN stus ON scci.st_mid = stus.stus_id WHERE ('1'='1')

I do not want to create operationBindig if it could work without that.

Could you give me advise on this?
thank you,
Szabi

[msca]

thread closeable

Hi,

Sorry, i missed something.
I set the ansi-style joins, and now i have got Left joins :)

The thread can close.

Thank you,
Szabi