Thread: RE: Outer joins

RE: Outer joins

From

"Trewern, Ben"

Date:

13 July 2001, 13:22:12

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

RE: Outer joins

From

wsheldah@lexmark.com

Date:

13 July 2001, 14:04:21


I think there should be a Postgres Features section.  It might be nice to have a
concise comparison chart comparing its features with, for instance, MySQL, SQL
Server 2000, Oracle, and any others that come up often in questions.  The
comparison chart should be frank while still unabashedly highlighting the many
places where PostgreSQL really shines.  You never know, some lazy journalist may
decide to copy and paste it into their next review.  ;--)




"Trewern, Ben" <Ben.Trewern%mowlem.com@interlock.lexmark.com> on 07/13/2001
10:06:41 AM

To:   pgsql-general%postgresql.org@interlock.lexmark.com
cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject:  RE: [GENERAL] 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.
*****************************************************************************

RE: Outer joins

From

Peter Eisentraut

Date:

13 July 2001, 16:12:13

Trewern, Ben writes:

> By the way should there be a 'Postgres Features' page on the website.

http://www.de.postgresql.org/features.html

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter