On Sep 10, 2004, at 3:36 PM, Jake Stride wrote:
> What I want to be able to do is:
>
> SELECT name, 3 FROM assets <<INTO>> assets
>
> Since id is a serial/has a default value you don't need to worry about
> it
> (iei the database should take care of it).
I think what you want to do is something along the lines of
INSERT INTO assets (name, jobno)
SELECT distinct name, 3
FROM assets
;
Michael