From: Wei Weng <wweng@kencast.com>
To: pgsql-sql@postgresql.org
Subject: Re: NULL values or not?
Date: Fri, 21 Dec 2001 16:37:52 -0500
Message-ID: <NEBBLAIMPMNDAPBMNGJNCEHKCCAA.wweng@kencast.com> (raw)
In-Reply-To: <web-533913@davinci.ethosmedia.com>
Forgive my ignorance, but what exactly is a "multi-column" join?
<snip>
> gb_accessions, the clones who are missing GB will not show up with a
> blank GB, instead they will not show up at all! You can get around this
> with OUTER JOINS, but OUTER JOINs are not dependable for multi-column
> joins.
<snip>
I also used a lot of NULLs in my table schemas though never in the
primary(foreign) keys. Is that bad?
Thank you.
==========
Wei Weng
Network Software Engineer
KenCast Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com
Subject: Re: NULL values or not?
In-Reply-To: <NEBBLAIMPMNDAPBMNGJNCEHKCCAA.wweng@kencast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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