Thread: ERROR: OUTER JOIN is not yet supported

ERROR: OUTER JOIN is not yet supported

From
"Jeff Martin"
Date:
Hello...I though PostgreSQL supports OUTER JOIN?  Do I need to compile with special options or something?
I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4
 
psql <<!
job=# select contact, phone from account left outer join phone on account.Id=Phone.AccountId;
ERROR:  OUTER JOIN is not yet supported
!
 
Thanks for any help,
 
Jeff

Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff@dgjc.org
www.dgjc.org

 

Re: ERROR: OUTER JOIN is not yet supported

From
Tom Lane
Date:
"Jeff Martin" <jeff@dgjc.org> writes:
> Hello...I though PostgreSQL supports OUTER JOIN?  Do I need to compile with
> special options or something?
> I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4

Time to update.

            regards, tom lane

Re: ERROR: OUTER JOIN is not yet supported

From
Darren Ferguson
Date:
I believe Postgres outer joins came out in 7.1.* don't remember which one
but it was the main reason for our company switching back to it

Darren Ferguson

On Sat, 2 Feb 2002, Tom Lane wrote:

> "Jeff Martin" <jeff@dgjc.org> writes:
> > Hello...I though PostgreSQL supports OUTER JOIN?  Do I need to compile with
> > special options or something?
> > I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4
>
> Time to update.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


Re: ERROR: OUTER JOIN is not yet supported

From
"Mitch Vincent"
Date:
    If anyone is debating on upgrading this weekend I'd suggest they wait
until Monday when 7.2 is released -- there are *lots* of advantages over
7.1.x and it would be a shame to spend the time upgrading to 7.1.3 just to
have to turn around and go to 7.2!

    I've been using the RCs in production for a few weeks without any
trouble, but I'm not sure I'd suggest anyone else copy me :-)

-Mitch


> I believe Postgres outer joins came out in 7.1.* don't remember which one
> but it was the main reason for our company switching back to it
>
> Darren Ferguson
>
> On Sat, 2 Feb 2002, Tom Lane wrote:
>
> > "Jeff Martin" <jeff@dgjc.org> writes:
> > > Hello...I though PostgreSQL supports OUTER JOIN?  Do I need to compile
with
> > > special options or something?
> > > I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4
> >
> > Time to update.
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>