On Wed, 2004-05-26 at 14:38, Bruno Wolff III wrote:
> On Wed, May 26, 2004 at 13:57:37 -0400,
> Vic Ricker <[EMAIL PROTECTED]> wrote:
> > Am I doing something wrong or is this a bug?
>
> Are there any nulls in iasusers.user_name?
There was a null in iasusers. I removed it and that fixed the pr
On Wed, May 26, 2004 at 13:57:37 -0400,
Vic Ricker <[EMAIL PROTECTED]> wrote:
> Hi. I'm using PostgreSQL 7.4.2 under Fedora Core 1.
>
> I have two tables with a single varchar(32) column in each. I'm trying
> to find all the rows from one table that don't exist in the other
> table. The query
Hi. I'm using PostgreSQL 7.4.2 under Fedora Core 1.
I have two tables with a single varchar(32) column in each. I'm trying
to find all the rows from one table that don't exist in the other
table. The query that I am using is:
select u.user_name from users u where u.user_name not in (select
use
