Madison Kelly wrote:
SELECT 'Y' AS local FROM domains d, users u WHERE u.usr_dom_id=d.dom_id
AND u.usr_email||'@'||d.dom_name IN ('[EMAIL PROTECTED]');
Though this may not be the most efficient. In my case, the 'usr_email'
is the LHS of the '@' sign and 'dom_name' is the domain name. If I
wan
Richard Huxton wrote:
Madison Kelly wrote:
nmc=> SELECT 'Y' AS local FROM domains WHERE '@'||dom_name IN
('[EMAIL PROTECTED]');
local
---
(0 rows)
Not work?
I don't think IN does what you think it does. It's not a substring-test,
but a set test:
SELECT 1 WHERE 'x' IN ('a','b','c','
Rodrigo De León wrote:
On 9/4/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
I am sure I am missing something simple. :)
Yeah...
'[EMAIL PROTECTED]' <> '@test.com'
Well now, don't I feel silly. *sigh*
Thanks!
Madi
---(end of broadcast)---
Madison Kelly wrote:
nmc=> SELECT 'Y' AS local FROM domains WHERE '@'||dom_name IN
('[EMAIL PROTECTED]');
local
---
(0 rows)
Not work?
I don't think IN does what you think it does. It's not a substring-test,
but a set test:
SELECT 1 WHERE 'x' IN ('a','b','c','x');
SELECT a FROM foo
On 9/4/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
> 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_na
On 9/4/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
>I am sure I am missing something simple. :)
Yeah...
'[EMAIL PROTECTED]' <> '@test.com'
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
('[EMAIL PROTECTED]');
local
---
(0 rows)
Not work?
I am sure
