>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 >
Hi Brian, Yes I tried the UNNEST but it produced the same error unfortunately. It's really odd, I'm not sure why it wants to see only 'stored' columns as part of the association. As of right now I'm not too concerned because the requirements have changed a bit so I won't be using that INSERT after all, but it still bugs me when something doesn't work the way I expect it to and I can't figure out why. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
