| From: | "Igor' Robul'" <igor(at)raduga(dot)dyndns(dot)org> |
|---|---|
| To: | Pgsql Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | SQL question |
| Date: | 2000-11-23 15:23:01 |
| Message-ID: | 20001123182301.A7557@linux.rainbow |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-11-23 15:23:24 | Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) |
| Previous Message | The Hermit Hacker | 2000-11-23 14:31:42 | Search engine on http://www.postgresql.org ... |