On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
<mail@webthatworks.it> wrote:
> To make it more concrete I came up with:
>
> select coalesce(u.mail,j.mail) from (
> select (array['m@example1.com','m@example2.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@example1.com'), ('m@example2.com')
) j(mail)
left join users u on upper(u.mail)=upper(j.mail);
merlin
