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