Re: help need it

On Tue, 8 Apr 2003, rute solipa wrote:

> i've an oracle query:
> 
> Select tb_users.ds_description, tb_users.cd_role, tb_users.cd_user, 
> tb_users.ds_login, tb_monitores.cod_equipa from tb_users, tb_monitores 
> where ds_login like 'varLogin' and ds_password like 'varPassword' and 
> tb_users.cd_user = tb_monitores.cd_user(+)
> 
> how can i transform it to an postgresql query?

Can you check the postgresql manual if the (+) operator
means something related to OUTER joins?
If yes then use [LEFT|RIGHT] OUTER JOIN of postgresql.

> 
> 
> best regards
> 
> etur
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr