Populating using Select - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Populating using Select
Date
Msg-id 55c095e90609260535r1951013ep15ec0d5a89c8a78a@mail.gmail.com
Whole thread Raw
Responses Re: Populating using Select  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
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> 

pgsql-sql by date:

Previous
From: TJ O'Donnell
Date:
Subject: Re: unique rows
Next
From: Andrew Sullivan
Date:
Subject: Re: Populating using Select