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 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); also worked. Thanks guys! -- Vic Ricker http://www.ricker.us/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
