Thank you very much Andrew. Now I learned.Best regardsFrom BrazilEzequias R. da Rocha2006/9/26, Andrew Sullivan <[EMAIL PROTECTED]
>: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 (nextva
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.cl
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(
