Let's suppose that I have an UPDATE query which includes a SELECT as part
of it as follows:
UPDATE table1
SET field1 = (SELECT fieldx FROM table2 WHERE .........)
What happens if the result of the SELECT command does not return any row?
Respectfully,
Jorge Maldonado
A scalar subquery that returns no rows has a result of NULL. This is
not specific to whether it's used in UPDATE. See
http://www.postgresql.org/docs/9.1/static/sql-expressions.ht[..]
regards, tom lane
--
Sent via pgsql-novice mailing list (pgsql-novice*******)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Related Topics
- PostgreSQL Query Speed Issues
- Install new perl test function in PostgreSQL
- Function returning SETOF returns nothing
- Materialized views in Oracle
- "Programmers can't get IPv6 thus that is why they do not have IPv6 in their applications"....
- Callingassassin directly yields very different results than callingassassin via amavis-new
Post a Comment
