Postgres Pro
Downloads
Home   >   mailing lists

Re: Outer join in postgresql - Mailing list pgsql-sql

From Jesus Aneiros
Subject Re: Outer join in postgresql
Date
Msg-id Pine.LNX.4.10.10006122101001.7310-100000@jagua.cfg.sld.cu
Whole thread Raw
In response to Outer join in postgresql  ("Patrick Kay" <patk@auctionsolutions.com>)
List pgsql-sql
Tree view 
There is no OUTER JOIN in postgres. You could use SELECT and UNION ALL.

Jesus.

On Mon, 12 Jun 2000, Patrick Kay wrote:

> I am looking for a way run an outer join in psql.  Can anyone help?
> 
> Informix has an "OUTER" keyword.  I don't see anything like this in the docs
> for psql.
> 
> Thanks much.
> -Pat Kay
>

pgsql-sql by date:

Previous
From: Alex
Date:
Subject: Simple search question
Next
From: newsuser@linux2.johnmckown.net (John McKown)
Date:
Subject: Re: Simple search question