From: Richard Huxton <dev@archonet.com>
To: imam <imam@effigent.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem while converting sybase quries to postgres
Date: Thu, 03 Feb 2005 09:33:41 +0000
Message-ID: <4201EFF5.5000006@archonet.com> (raw)
In-Reply-To: <003901c5082d$bac76f30$1301a8c0@eipl.com>
References: <003901c5082d$bac76f30$1301a8c0@eipl.com>
imam wrote:
> The following is a sybase query and i am trying to convet it into
> postgres but in postgres the join will be specified in from clause
> and we cannot specify any logical operator
>
> i would be grateful if you could tell me the solution for it
You don't actually say what your query is trying to do.
> SELECT t1.SR_TRAN_HEAD_PK AS ReceiptHeaderPK,
> t1.ADJ_TRAN_ID AS AdjustmentTransactionID,
...other columns...
> FROM PE_POP_SR_POSTED_TRAN_HEAD t1,
> PE_POP_PO_HEADER t2,
> PE_POP_SR_POSTED_TRAN_DET t3
> Where t1.SR_TRAN_HEAD_PK = t3.SR_TRAN_HEAD_PK
> and (t1.PO_HEADER_PK *= t2.PO_HEADER_PK or t3.PO_HEADER_PK *=
> t2.PO_HEADER_PK)
If this is a left outer join, you could do something like:
SELECT
...
FROM
pe_pop_sr_posted_tran_head t1
LEFT JOIN
pe_pop_po_header t2
ON
t1.po_header_pk = t2.po_header_pk
LEFT JOIN
pe_pop_sr_posted_tran_det t3
ON
t2.po_header_pk = t3.po_header_pk
AND t1.sr_tran_head_pk = t3.sr_tran_head_pk
But you'll want to test it because I'm not clear what your query is doing.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, imam@effigent.net
Subject: Re: problem while converting sybase quries to postgres
In-Reply-To: <4201EFF5.5000006@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox