RE: Outer joins

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.iannuccelli@toulouse.inra.fr]
Sent: 13 July 2001 18:51
Cc: pgsql-general@postgresql.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@postgresql.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.
*****************************************************************************