How can you select into variable in PostgreSQL?

Question

I have the following function:

Create or Replace Function someFunction([parameter1], [parameter2]) Returns Integer As $$
Declare
    someInt_ integer;
    totalRows_ integer;
Begin
    SELECT x INTO someInt_, COUNT(*) INTO totalRows_ 
    FROM [table]
    WHERE [some conditions];

    [more code]
End;
$$ Language 'plpgsql';

The problem is that I get the following error:

ERROR:  «count» is not a known variable
LINE 6:  SELECT x INTO someInt_, COUNT(*) INTO totalRows_ ...
                                 ^
SQL state: 42601
Character: 181

How can I fix this?

I know a lot of data is missing, such as the return. It is because I have simplified it since the variables are in another language.

user330315 · Accepted Answer · 2020-05-11 16:11:09Z

2

The INTO comes after all columns:

SELECT x, COUNT(*)
   INTO someInt_, totalRows_ 
FROM [table]
WHERE [some conditions];

answered May 11, 2020 at 16:11

user330315

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

Collectives™ on Stack Overflow

How can you select into variable in PostgreSQL?

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