Port Bug Report: Joins (does not support outer, left, right) - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Joins (does not support outer, left, right)
Date
Msg-id 199905311328.JAA90997@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Deva Vejay
Your email address      : devavejay@preveho.com

Category                : runtime: back-end: SQL
Severity                : non-critical

Summary: Joins (does not support outer, left, right)

System Configuration
--------------------
  Operating System   : Linux 2.0.34

  PostgreSQL version : 6.2

  Compiler used      :

Hardware:
---------
Redhat, Pentium II 400 128 m Ram,


Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
We are trying to migrate our product to Linux! and our
backend to Postgresql!! The major problem we are in countering
is that our product uses tons of outer, and left joins.
We were wondering if there is any method of limiting the result
set of a quary to mimic an outer or left join with out using
the keywords outer and left.

--------------------------------------------------------------------------

Test Case:
----------


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Unprivileged user
Date:
Subject: Port Bug Report: Wrong matching with LC_COLLATE=cs_CZ
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: fatal error occurs while building index