On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
<mail@xxxxxxxxxxxxxxx> wrote:
> To make it more concrete I came up with:
>
> select coalesce(u.mail,j.mail) from (
> select (array['m@xxxxxxxxxxxx','m@xxxxxxxxxxxx'])[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@xxxxxxxxxxxx'), ('m@xxxxxxxxxxxx')
) j(mail)
left join users u on upper(u.mail)=upper(j.mail);
merlin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
