This is my code:
amount INTEGER;
amount := select count(*) from moneyTable;
I'm getting the following error:
ERROR: syntax error at or near "select"
Can someone help me out.
-
What do you want to achieve?trkoch– trkoch2015-11-18 01:03:09 +00:00Commented Nov 18, 2015 at 1:03
-
@MrsEd im trying to store the number of tuples in the variable amount. Then use that variable later for other processing. But currently im getting that syntax error and I have no idea why this is happening.Brandon– Brandon2015-11-18 01:25:18 +00:00Commented Nov 18, 2015 at 1:25
Add a comment
|
2 Answers
From the fine manual:
An assignment of a value to a PL/pgSQL variable is written as:
variable { := | = } expression;
but select ... isn't an expression. If you want to assign values from a SELECT to variables, you want to use INTO:
select count(*) into amount from moneyTable;
-- ^^^^^^^^^^^
4 Comments
Brandon
Now im getting the error ERROR: syntax error at or near " * ". CONTEXT: invalid type name "count(*) into amount from moneyTable"
mu is too short
Should work fine (sqlfiddle.com/#!15/6558d/1 (sorry about the function formatting, sqlfiddle has problems with multi-line dollar-quoted strings it seems)). You're doing this inside a function, right?
Brandon
I have it in the declaration part of my function
mu is too short
You should have that assignment in the body of the function. A bit of time with the PL/pgSQL documentation might be useful as well.
Either the @mu is to short answer or this
amount := (select count(*) from moneyTable);
