On Mon, 26 Oct 2009 14:15:26 +0100 Ivan Sergio Borgonovo <m...@webthatworks.it> wrote:
> I've a list of emails and a list of users (with emails). > > If the list of emails was already inside a table > > create table mails ( > mail varchar(64) > ); > > create table users ( > name varchar(127), > mail varchar(64) > ); > > I'd do: > select coalesce(u.mail, m.mail) from mails left join users on > u.mail=m.mail; > > Now mails are into a php array and they may be in the range of 5000 > but generally less. > > The final query will be something like > insert into mailqueue (qid, uid, mail, ...) select ... > > and since some fields are pseudo random sequences computed from a > serial, it would be "clean" to do it just in one query. > Any clean technique? 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); but I sincerely dislike it. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
