SQL question - Mailing list pgsql-general

From Igor' Robul'
Subject SQL question
Date
Msg-id 20001123182301.A7557@linux.rainbow
Whole thread Raw
List pgsql-general
Hello,

For example:
SELECT words.id, files.id FROM words,files WHERE w=$1 and host=$2 and name=$3;

If words table has $1 and files table has $2 and $3 then I'll get
result like
id1 id2
-------
223 235

But if words or files does not have corresponding info then it will
return empty relation.

Is it possible get something like
id1 id2
--------
234 NULL

Thank you for info.

--
Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

pgsql-general by date:

Previous
From: Philip Warner
Date:
Subject: Matrix implementation?
Next
From: "turing2000"
Date:
Subject: ...