RE: Outer joins

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: RE: Outer joins
Date: 2001-07-13 14:06:41
Message-ID: 996802F75C3CD411B424001083FA445B059589@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres 7.1 does support Left, right & outer joins. Functions are similar
to stored procedures but they cannot return rows. I think that this
limitation is being worked on for the next release (7.2).

By the way should there be a 'Postgres Features' page on the website. This
would save a large amount of these queries and reduce the amount of e-mails
on this list. I'm sure that lots of interest is being raised because of the
'Redhat Database' Announcement. Some of these people will just want to know
what Postgres is capable of.

Regards

Ben

> -----Original Message-----
> From: eddie iannuccelli [mailto:eddie(dot)iannuccelli(at)toulouse(dot)inra(dot)fr]
> Sent: 13 July 2001 18:51
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Outer joins
>
>
> Can anyone confirm me that Postgres 7.1 does not support outer join ?
> Are functions similar to classical stored procedure ?
>
> thanks
> --
> **************************************************
> Eddie IANNUCCELLI - tel: 05 61 28 54 44
> INRA, Laboratoire de Génétique Cellulaire
> Chemin de Borde Rouge - Auzeville -BP27
> 31326 Castanet Tolosan
> **************************************************
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>

Sorry about the footer it's automatic.

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-13 14:22:30 Re: Outer joins
Previous Message Martijn van Oosterhout 2001-07-13 13:51:40 [PATCH] To remove EXTEND INDEX