SELECT question (splitting a field) - Mailing list pgsql-general

Hi all,

   Hopefully a quick question...

   Why does:

nmc=> SELECT 'Y' AS local FROM domains WHERE dom_name='test.com';
  local
-------
  Y
(1 row)

   Work but:

nmc=> SELECT 'Y' AS local FROM domains WHERE '@'||dom_name IN
('mkelly@test.com');
  local
-------
(0 rows)

   Not work?

   I am sure I am missing something simple. :)

Thanks!!

Madi