Обсуждение: ERROR: OUTER JOIN is not yet supported

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
>