pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feeddocumentation for joins
4+ messages / 4 participants
[nested] [flat]
* documentation for joins
@ 2002-04-13 21:24 MJS <M.Sacha@elka.pw.edu.pl>
0 siblings, 3 replies; 4+ messages in thread
From: MJS @ 2002-04-13 21:24 UTC (permalink / raw)
To: pgsql-docs
Hi!
I found that there's no any suffiction documentation for joins. Are they
supported in Postgres? If so, how? How to make outter joins or natural
joins? Is the where clause the only way to join tables?
Please help me or show the place where I can get the answers.
MJS
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documentation for joins
@ 2002-04-15 15:13 Roberto Mello <rmello@cc.usu.edu>
parent: MJS <M.Sacha@elka.pw.edu.pl>
2 siblings, 0 replies; 4+ messages in thread
From: Roberto Mello @ 2002-04-15 15:13 UTC (permalink / raw)
To: MJS <M.Sacha@elka.pw.edu.pl>; +Cc: pgsql-docs
On Sat, Apr 13, 2002 at 11:24:30PM +0200, MJS wrote:
> Hi!
> I found that there's no any suffiction documentation for joins. Are they
> supported in Postgres? If so, how? How to make outter joins or natural
> joins? Is the where clause the only way to join tables?
Sure they are. You didn't look very hard apparently.
PostgreSQL 7.2.1 User's Guide
2. Queries
2.2. Table Expressions
2.2.1. FROM clause
2.2.1.1. Joined Tables
2.2.2. WHERE clause
http://www.postgresql.org/idocs/index.php?queries.html
How about the reference manual? It has a whole spew on joins on the
documentation for SELECT.
http://www.postgresql.org/idocs/index.php?sql-select.html
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
In Borland you are never bored!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documentation for joins
@ 2002-04-15 16:10 Hannu Krosing <hannu@tm.ee>
parent: MJS <M.Sacha@elka.pw.edu.pl>
2 siblings, 0 replies; 4+ messages in thread
From: Hannu Krosing @ 2002-04-15 16:10 UTC (permalink / raw)
To: MJS <M.Sacha@elka.pw.edu.pl>; +Cc: pgsql-docs
On Sat, 2002-04-13 at 23:24, MJS wrote:
> Hi!
> I found that there's no any suffiction documentation for joins. Are they
> supported in Postgres? If so, how? How to make outter joins or natural
> joins? Is the where clause the only way to join tables?
>
> Please help me or show the place where I can get the answers.
Try:
http://www.postgresql.org/idocs/index.php?tutorial-join.html
----------
Hannu
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documentation for joins
@ 2002-04-15 16:28 Bruno Wolff III <bruno@wolff.to>
parent: MJS <M.Sacha@elka.pw.edu.pl>
2 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2002-04-15 16:28 UTC (permalink / raw)
To: MJS <M.Sacha@elka.pw.edu.pl>; +Cc: pgsql-docs
On Sat, Apr 13, 2002 at 11:24:30PM +0200,
MJS <M.Sacha@elka.pw.edu.pl> wrote:
> Hi!
> I found that there's no any suffiction documentation for joins. Are they
> supported in Postgres? If so, how? How to make outter joins or natural
> joins? Is the where clause the only way to join tables?
>
> Please help me or show the place where I can get the answers.
Joins are documented under the 'select' command.
Outer joins have been available since version 7.1.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-04-15 16:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-13 21:24 documentation for joins MJS <M.Sacha@elka.pw.edu.pl>
2002-04-15 15:13 ` Roberto Mello <rmello@cc.usu.edu>
2002-04-15 16:10 ` Hannu Krosing <hannu@tm.ee>
2002-04-15 16:28 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox