help need it

From: rute solipa <rutes(at)eselx(dot)ipl(dot)pt>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: help need it
Date: 2003-04-08 14:58:57
Message-ID: 3E92E3B1.7070405@eselx.ipl.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

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?

best regards

etur

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-04-08 15:16:34 Re: help need it
Previous Message Robert Treat 2003-04-07 17:17:35 Re: ext3 filesystem / linux 7.3

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-04-08 15:16:34 Re: help need it
Previous Message Christoph Haller 2003-04-08 14:37:42 Re: Language SQL, But Need Return PlPgSql