unable to assign value to variable in plpgsql

From: Chirag Mittal <linux(at)seasonstravel(dot)co(dot)in>
To: pgsql-novice(at)postgresql(dot)org
Subject: unable to assign value to variable in plpgsql
Date: 2014-02-16 12:22:28
Message-ID: 1392553348538-5792281.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,I am trying to assign number of row as integer Tried 1maz int :=(SELECT
count(col1) FROM table WHERE col1 = quote_literal(in val1));Tried 2EXECUTE
'SELECT count(col1) FROM table WHERE col1 = quote_literal(val1) INTO
maz';getting error INTO RegardsChirag

--
View this message in context: http://postgresql.1045698.n5.nabble.com/unable-to-assign-value-to-variable-in-plpgsql-tp5792281.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vik Fearing 2014-02-16 16:06:55 Re: unable to assign value to variable in plpgsql
Previous Message Adrian Klaver 2014-02-15 15:30:09 Re: