On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <sclark@xxxxxxxxxxxxx> wrote: > srm2=# explain > srm2-# INSERT INTO Myevents > srm2-# SELECT * > ERROR: INSERT has more expressions than target columns > srm2=# explain > srm2-# INSERT INTO Myevents > srm2-# SELECT * > ERROR: INSERT has more expressions than target columns Oops, replace SELECT * with SELECT A.*. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
