Thread: ERROR: OUTER JOIN is not yet supported
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
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
"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
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 >
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
>