error: subquery must return only one column during insert

Question

I have next code:

INSERT INTO some_table (id, value1, value2, value3)
      VALUES (
        (SELECT id FROM user_table WHERE some_column = 'data'), 
        (SELECT value1, value2 FROM event_table WHERE type = 'some_type'),
        value3
      )

And I am getting next error: subquery must return only one column This error related to second 'select', but I don't understand why. I should return two values and it is ok.

Gordon Linoff · Accepted Answer · 2020-07-15 14:45:30Z

3

Use insert . . . select`:

INSERT INTO some_table (id, value1, value2, value3)
    SELECT ut.id, et.value1, et.value2, <value3>
    FROM user_table ut JOIN
         event_table et
         ON ut.some_column = 'data' AND et.type = 'some_type';

Notes:

It is not clear where value3 comes from. I assume it is a constant of some sort.
This version will not return any rows if the conditions do not match in either table. I assume this is a feature and not a bug.

answered Jul 15, 2020 at 14:45

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error: subquery must return only one column during insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related