SELECT question (splitting a field)

From: Madison Kelly <linux(at)alteeve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT question (splitting a field)
Date: 2007-09-04 18:47:11
Message-ID: 46DDA82F.9080105@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)test(dot)com');
local
-------
(0 rows)

Not work?

I am sure I am missing something simple. :)

Thanks!!

Madi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message blay bloo 2007-09-04 18:53:16 How to 'register' functions, so they can be called (plpythonu)
Previous Message Yonatan Ben-Nes 2007-09-04 18:46:10 Database owner can't analyze/vacuum all of the database tables