Populating using Select

Hi list,

I need to populate a neigborhood table base on a select of another table
that already have a good amount of neigborhood saved.

Could someone tell me how it is possible ?

I was trying to make something like this:

Insert into base.neigborhood values (nextval(), Select distinct name from
base.clients).

I didn't try it but I suppose it will not work.

Regards ...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/