Thank you very much Andrew. Now I learned.
Best regards
From Brazil
Ezequias R. da Rocha
2006/9/26, Andrew Sullivan <ajs@crankycanuck.ca >: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'),
name
FROM base.clients
GROUP 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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/
