NikhilS wrote:

I have tried some update-subselect variations and they seem to work. For
example the case in the src/test/regress/sql/update.sql, which used to
fail till now, seems to work:

UPDATE update_test SET (a,b) = (select a,b FROM update_test where c =
'foo')
WHERE a = 10;
What's the expected result if the tuple from subselect is more than 1?
I expect no update at all in case of void result set, is this the case ?



Regards
Gaetano Mendola

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 12 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMar 15, '07 at 6:06a
activeApr 11, '07 at 9:04a
posts12
users3
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase