-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF+Vx47UpzwH2SGd4RAvyVAKCGK5pC9B/lmrNjAFPGXhm5ialwSwCglM2n DxrxWyvJASX5WSF9B8cAMas= =AoVF -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
