Обсуждение: 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> 

On Tue, Sep 26, 2006 at 09:35:18AM -0300, Ezequias Rodrigues da Rocha wrote:
> I was trying to make something like this:
> 
> Insert into base.neigborhood values (nextval(), Select distinct name from
> base.clients).

Not quite.  

INSERT INTO base.neighborhood (column list)SELECT nextval('sequence name'),    nameFROM    base.clientsGROUP BY name;

Note that this will give you a different number for each of the
names.  If what you want is for them all to have the same number,
then perform the nextval and then call currval() on the sequence.

By the way, this is a pretty common use of SQL (inserting into one
table the results of a select from another).  If you thought this
wouldn't work, you maybe need a little more SQL practice than you
think you do.  Any of the excellent PostgreSQL books out there should
cover this much.  Alternatively, the standard SQL introductions would
get you there.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.                --Brad Holland

Thank you very much Andrew. Now I learned.

Best regards
From Brazil
Ezequias R. da Rocha




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  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/