From: imam <imam@effigent.net>
To: pgsql-sql@postgresql.org
Subject: problem while converting sybase quries to postgres
Date: Tue, 1 Feb 2005 12:44:50 +0530
Message-ID: <003901c5082d$bac76f30$1301a8c0@eipl.com> (raw)
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
SELECT t1.SR_TRAN_HEAD_PK AS ReceiptHeaderPK,
t1.ADJ_TRAN_ID AS AdjustmentTransactionID,
t1.TOTAL_QTY_INVOICED AS TotalQtyInvoiced,
t1.TOTAL_QTY_MATCHED AS TotalQtyMatched,
t1.VENDOR_ID AS VendorID,
t1.COMMENTS AS Comments,
t1.SR_NUMBER AS ShipmentReceiptNumber,
t1.SHIPMENT_RECEIPT_DATE AS ReceiptDate,
t1.POSTING_DATE AS PostingDate,
t2.PO_HEADER_PK AS POHeaderPK,
t1.VENDOR_DOCUMENT_NUMBER AS VendorDocumentNumber,
t1.TRAN_STATUS_ID AS TransactionStatusID,
t1.SR_TOTAL AS ReceiptTotal,
t1.SR_BATCH_NUMBER AS ReceiptBatchNumber,
t1.VENDOR_PK AS VendorPK,
t1.TOTAL_QTY_RECEIVED AS TotalQtyReceived,
t1.TOTAL_QTY_REJECTED AS TotalQtyRejected,
t2.PO_NUMBER AS PONumber,
t2.BUYER_PK AS BuyerPK,
t2.BILLING_TERMS_PK AS BillingTermsPK,
t2.PO_GROUP_PK AS POGroupPK,
t2.PURCHASE_ORDER_TYPE_PK AS POTypePK,
t2.PO_DELIVERY_METHOD_PK AS PODeliveryMethodPK,
t2.CUSTOMER_PK AS CustomerPK,
t2.PO_HEADER_STATUS_PK AS POHeaderStatusPK,
t2.BUYER_ID AS BuyerID,
t2.PO_GROUP AS POGroup,
t2.PO_TYPE AS POType,
t2.PO_DATE AS PODate,
t2.PO_HEADER_STATUS AS POStatus,
t2.IS_PO_ON_HOLD AS POonHold,
t2.TRADE_DISCOUNT AS TradeDiscount,
t2.SHIPPING_CHARGES AS ShippingCharges,
t2.OTHER_CHARGES AS OtherCharges,
t2.PO_TAX AS POTax,
t2.PO_SUB_TOTAL AS POSubTotal,
t2.PO_DISCOUNT AS PODiscount,
t2.PO_TOTAL AS POTotal,
t2.PO_TOTAL_QTY AS TotalQty,
t2.RELEASED_DATE AS ReleasedDate,
t3.AMT_APPORTIONED AS AmtApportioned,
t3.MODIFIED_RECEIVED_QTY AS ModifiedReceivedQty,
t3.QTY_INVOICED AS QtyInvoiced,
t3.QTY_MATCHED AS QtyMatched,
t3.STATUS_ID AS StatusID,
t3.INV_COST AS InvoiceCost,
t3.AMT_INVOICE_APPORTIONED AS AmtInvoiceApportioned,
t3.SR_TRAN_DETAIL_PK AS ReceiptDetailPK,
t3.WAREHOUSE_PK AS WarehousePK,
t3.UNIT_COST AS UnitCost,
t3.QTY_RECEIVED AS QtyReceived,
t3.EXT_COST AS ExtendedCost,
t3.QTY_REJECTED AS QtyRejected,
t3.REASON_FOR_REJECTION AS ReasonforRejection,
t3.BILL_OF_LADING AS BillofLading,
t3.ITEM_ID AS ItemID,
t3.WAREHOUSE_ID AS WarehouseID,
t3.ITEM_PK AS ItemPK,
t3.UOM_PK AS UomPK,
t3.UOM_ID AS UomID,
t3.QTY_FOR_BASE_UOM AS BaseUOM,
t3.UNIT_COST_FOR_BASE_UOM AS UnitCostforBaseUOM,
t3.ITEM_NAME AS ItemName,
t3.ITEM_ALTERNATE_NAME AS ItemAlternateName,
t3.PO_DETAIL_PK AS PODetailPK
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)
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: imam@effigent.net
Subject: Re: problem while converting sybase quries to postgres
In-Reply-To: <003901c5082d$bac76f30$1301a8c0@eipl.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