On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)it> wrote:
> To make it more concrete I came up with:
>
> select coalesce(u.mail,j.mail) from (
> select (array['m(at)example1(dot)com','m(at)example2(dot)com'])[i] as mail
> from generate_series(1,2) i) j
> left join users u on upper(u.mail)=upper(j.mail);
how about this:
select coalesce(u.mail,j.mail) from
(
values ('m(at)example1(dot)com'), ('m(at)example2(dot)com')
) j(mail)
left join users u on upper(u.mail)=upper(j.mail);
merlin