Does it matter that the subquery isn't enclosed in ()? Could it be confusing the WHERE clause to be looking for col2 in mytable vs in table?
George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Shane Ricciardi > Sent: Monday, December 20, 2010 7:59 PM > To: [email protected] > Subject: Re: [U2] uv SQL INSERT INTO error? > > >Brian Leach <brian <at> brianleach.co.uk> writes: > > > > > Hi Shane > > > > Not sure exactly what the problem is, but what happens if you rewrite > this > > as: > > > > INSERT INTO myTable (val1, val2, val2) SELECT col1, col2, col3 FROM > UNNEST > > table ON testAssoc WHERE col2 >= '10-23-10'; > > > > I know it *should* be the same, but ... > > > > Brian > > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
