Marco Bambini said: > If I do > update TABLE_B set column1 = ( select column1 from table_A ) > > I expexct to get an error since "select column1 from table_a" is > multivalued > But I dont. The update succeeds as though I wrote "update TABLE_B set > column1 = ( select column1 from table_A returning 1 row )" or something > Table_B is updated with the first result from the subselect. > > Any idea?
Stop writing non-correct SQL and being surprised when it gives you non-correct results? That's obviously not an option if you're not the one who will be writing the SQL that gets passed to the engine, but if you'll be writing all of the SQL yourself, you can avoid the problem by not doing something that you know shouldn't work. Clay Dowling -- Simple Content Management http://www.ceamus.com
