Hi all
I'm new in PL/PGSQL developing, I'm trying to initialize a variable from a
SQL query, this query counts some rows, I've made the next code, but it
doesn't work.
CREATE FUNCTION schema.myFunction() RETURNS BOOLEAN AS $$
DECLARE
counter RECORD;
BEGIN
SELECT * INTO STRICT counter FROM (SELECT COUNT (DISTINCT (rows)) FROM
schema.table);
I'm pretty annoyed, because I've found some examples that use this kind of
variable initialization.
Is there someone who know what I did wrong?
Thanks!
--
View this message in context:
http://www.nabble.com/Initializing-variables-from-SQL-query-tp22612191p22612191.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
