Populating using Select

Hi list,<br /><br />I need to populate a neigborhood table base on a select of another table that already have a good
amountof neigborhood saved.<br /><br />Could someone tell me how it is possible ?<br /><br />I was trying to make
somethinglike this: <br /><br />Insert into base.neigborhood values (nextval(), Select distinct name from
base.clients).<br/><br />I didn't try it but I suppose it will not work.<br /><br /><br />Regards ...<br clear="all"
/><br/>-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>