Subquery must return only one column error?

S

Steve2021-01-15 10:53:18

PostgreSQL

Steve, 2021-01-15 10:53:18

Throws subquery must return only one column error.
I want to output an array. What's wrong here?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Melkij, 2021-01-15
@melkij

So what is not clear in the text of the error?
do you see subquery in your query? How many columns are in its result? Well, obviously more than one, otherwise this subquery would not be needed at all.

Similar questions

A

Andrew2018-01-29 18:46:30

How to implement a search by last name in the database? 2Reply

A

Andrey2015-09-28 10:27:54

Migrating from Mysql to PostgreSQL, how to disable key checking? 1Reply

K

Konstantin2011-02-22 19:03:27

Migrating PostgreSQL databases after upgrading from 8.3 to 8.4 1Reply

F

FrontCatBackend2021-06-11 10:04:52

How to add another child record to the parent record in Sequelize + express? 0Reply

A

Alexey2020-04-18 11:10:07

How to find the cause of "Exception: idle transaction timeout" in a Flask+psycopg2+postgresql+pgbouncer application? 2Reply

Didn't find what you were looking for?

Ask your question