On Wed, 2004-05-26 at 14:38, Bruno Wolff III wrote:
> On Wed, May 26, 2004 at 13:57:37 -0400,
> Vic Ricker <vicricker(at)charter(dot)net> 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 problem.
I'm not sure that I understand why. It doesn't seem very intuitive...
Tom Innes's suggestion of:
select u.user_name from users u where u.user_name not in (select
user_name from iasusers ia where ia.user_name = u.user_name);
In response to
pgsql-bugs by date
|Next:||From: Sergey N. Yatskevich||Date: 2004-05-26 21:53:52|
|Subject: Bug in ECPG preprocessor|
|Previous:||From: Bruno Wolff III||Date: 2004-05-26 18:38:24|
|Subject: Re: Question regarding 'not in' and subselects|