Re: [SQL] Populating using Select

2006-09-26 Thread Ezequias Rodrigues da Rocha
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

Re: [SQL] Populating using Select

2006-09-26 Thread Andrew Sullivan
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(