Skip site navigation (1) Skip section navigation (2)

Re: Help me to understand (documentation)

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Виктор Вислобоков <corochoone(at)gmail(dot)com>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Help me to understand (documentation)
Date: 2009-08-16 20:43:30
Message-ID: 20090816204330.GG3940@eddie (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
On Sun, Aug 16, 2009 at 11:40:21AM +0400, Виктор Вислобоков wrote:
>    Thanks, Joshua.
>    I understand the difference JOIN and WHERE, but I'm very appreciate your
>    explanation.
>    My goal is a bit other, I want to translate the phrase "as is" (in compact
>    form)

The phrase you mentioned indicates that the ON and USING clauses not only
filter out rows, like a WHERE clause would, but also instruct the join to add
NULL values for rows in one relation that aren't matched by rows in the other
relation. Does that help at all? For whatever it's worth, my experience with
translation is that sometimes you've got to pretty much rewrite the original
either because a literal translation doesn't work in the language of choice,
or because the original text didn't make sense in the source language to begin
with. This case may include a little of both :)

Joshua Tolley / eggyknap
End Point Corporation

In response to

pgsql-docs by date

Next:From: Andreas WenkDate: 2009-08-17 10:10:29
Subject: Re: wording for Simple CASE and Searched CASE
Previous:From: Виктор ВислобоковDate: 2009-08-16 07:40:21
Subject: Re: Help me to understand (documentation)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group