On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
<m...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
