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.
*****************************************************************************