Hello, I have quite strange behavior of the following SQL: insert into address (cid,email) select distinct '49'::int,member.email from member imit 1 ; It should insert just 1 record. But it insert all recodrs which will be selected by subselect... What's wrong with this SQL? Or this is a bug? If it is a bug... How to fix it (patch, workaround...) Thanks in advance. -- Sincerely Yours, Denis Perchine ---------------------------------- E-Mail: [EMAIL PROTECTED] HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 ----------------------------------