Re: unable to assign value to variable in plpgsql - Mailing list pgsql-novice

On Sun, Feb 16, 2014 at 04:22:28AM -0800, Chirag Mittal wrote:
>Hi, I am trying to assign number of row as integer Tried 1 maz int :=(SELECT
>count(col1) FROM table WHERE col1 = quote_literal(in val1)); Tried 2 EXECUTE
>'SELECT count(col1) FROM table WHERE col1 = quote_literal(val1) INTO maz';
>getting error INTO Regards Chirag

select count(*)
into maz
from tablename
where col1 = 'val1';

maz int := count(*) from tablename where col1 = 'val1';

M.