Re: ERROR: OUTER JOIN is not yet supported

Started by Tom Laneabout 24 years ago3 messagesgeneral
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

"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

#2Darren Ferguson
darren@crystalballinc.com
In reply to: Tom Lane (#1)

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:

Show quoted text

"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

#3Mitch Vincent
mitch@doot.org
In reply to: Darren Ferguson (#2)

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

Show quoted text

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