blocks|key|3368616|text|这意味着嵌套的SELECT返回多个行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3368617|您需要在其中添加一个适当的WHERE子句。|3368618|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This means your nested SELECT returns more than one rows. 

You need to add a proper WHERE clause to it.

blocks|key|3339101|text|此错误意味着SELECT+store_key+FROM+store查询在SERVER1数据库中返回了两行或多行。如果要更新所有客户，请使用联接而不是标量=运算符。为了做到这一点，您需要一个条件来“连接”客户来存储项目。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3339102|如果希望将所有customer_id更新为同一个store_key，则需要向远程执行的SELECT提供一个WHERE子句，以便查询返回单个行。|3339103|entityMap^0|6|R|10|7|24|1|0|7|B|O|9|17|6|1H|5|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|I|$]]

This error means that the <code>SELECT store_key FROM store</code> query has returned two or more rows in the <code>SERVER1</code> database. If you would like to update all customers, use a join instead of a scalar <code>=</code> operator. You need a condition to "connect" customers to store items in order to do that.

If you wish to update all <code>customer_id</code>s to the same <code>store_key</code>, you need to supply a <code>WHERE</code> clause to the remotely executed <code>SELECT</code> so that the query returns a single row.

blocks|key|3339132|text|查询产生的结果是没有需要适当处理的行，如果在查询中提供有效的处理程序(如1+)，则可以解决此问题。将查询限制为返回一行2。还可以通过提供返回单行的"select+max(列)“来完成这一任务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3339133|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The result produced by the Query is having no of rows that need proper handling this issue can be resolved if you provide the valid handler in the query like
1. limiting the query to return one single row 
2. this can also be done by providing "select max(column)" that will return the single row

blocks|key|3339151|text|在有一对多关系的情况下，通过将IN，改为=，通常可以简单地解决根本问题。例如，如果您想更新或删除给定客户的一组帐户：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|3339152|WITH+accounts_to_delete+AS+
++++(+
++++++++SELECT+++++account_id
++++++++FROM+++++++accounts+a
++++++++INNER+JOIN+customers+c
++++++++++++++++ON+a.customer_id+=+c.id
++++++++WHERE++++++c.customer_name='Some+Customer'
++++)

--+this+fails+if+"Some+Customer"+has+multiple+accounts,+but+works+if+there's+1:
DELETE+FROM+accounts
+WHERE+accounts.guid+=+
(+
++++SELECT+account_id+
++++FROM+++accounts_to_delete+
);

--+this+succeeds+with+any+number+of+accounts:
DELETE+FROM+accounts
+WHERE+accounts.guid+IN+++
(+
++++SELECT+account_id+
++++FROM+++accounts_to_delete+
);|code-block|syntax|javascript|3339153|entityMap^0|F|2|F|2|K|1|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|D]|$9|S|A|T|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|U|8|@]|E|@]|F|$J|K]]|$1|L|3|-4|5|6|7|V|8|@]|E|@]|F|$]]]|M|$]]

The fundamental problem can often be simply solved by changing an <code>=</code> to <code>IN</code>, in cases where you've got a one-to-many relationship. For example, if you wanted to update or delete a bunch of accounts for a given customer:

<pre><code>WITH accounts_to_delete AS 
 ( 
 SELECT account_id
 FROM accounts a
 INNER JOIN customers c
 ON a.customer_id = c.id
 WHERE c.customer_name='Some Customer'
 )

-- this fails if "Some Customer" has multiple accounts, but works if there's 1:
DELETE FROM accounts
 WHERE accounts.guid = 
( 
 SELECT account_id 
 FROM accounts_to_delete 
);

-- this succeeds with any number of accounts:
DELETE FROM accounts
 WHERE accounts.guid IN 
( 
 SELECT account_id 
 FROM accounts_to_delete 
);
</code></pre>

blocks|key|1748778|text|使用限制1-因此它将只返回1行。示例|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1748779|customerId-+(从枚举中选择id，其中enumerations.name+=‘就绪发票’限制1)|1748780|entityMap^0|0|G|0|0|A|J|2|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

USE LIMIT 1 - so It will return only 1 row.
Example
customerId- (select id from enumeration where enumerations.name = 'Ready To Invoice' limit 1)

I have two separate databases. I am trying to update a column in one database to the values of a column from the other database:

<pre><code>UPDATE customer
SET customer_id=
 (SELECT t1 FROM dblink('port=5432, dbname=SERVER1 user=postgres password=309245',
 'SELECT store_key FROM store') AS (t1 integer));
</code></pre>

This is the error I am receiving:

<blockquote>
<pre><code>ERROR: more than one row returned by a subquery used as an expression
</code></pre>
</blockquote>

Any ideas?

Postgres Error: More than one row returned by a subquery used as an expression

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有两个独立的数据库。我试图将一个数据库中的一个列从另一个数据库更新为一个列的值：UPDATE customerSET customer_id=   (SELECT t1 FROM dblink('port=5432, dbname=SERVER1 user=postgres password=309245',   '...

问Postgres错误:由用作表达式的子查询返回的多行
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgres错误:由用作表达式的子查询返回的多行EN