SELECT INTO returns incorrect values - Mailing list pgsql-general

From Bill Todd
Subject SELECT INTO returns incorrect values
Date
Msg-id 48B8B484.1030808@dbginc.com
Whole thread Raw
Responses Re: SELECT INTO returns incorrect values  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: SELECT INTO returns incorrect values  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
The following SELECT INTO returns incorrect values in the variables
CATEGORY_NAME and PARENT_ID. If I copy the SELECT statement to pgAdmin,
delete the INTO clause and run the query it returns the correct values.
I am new to PostgreSQL and I must have something syntactically wrong in
the SELECT but I can't see what it is. Any suggestions?

DECLARE
  PARENT_ID BIGINT;
  CATEGORY_NAME VARCHAR(40);
BEGIN
      SELECT CATEGORY, PARENT_CATEGORY_ID
      INTO CATEGORY_NAME, PARENT_ID
      FROM NOTE.CATEGORY
      WHERE CATEGORY_ID = 477;
      RAISE NOTICE 'CURR CAT, NAME, PARENT ID: % % ', CATEGORY_NAME,
PARENT_ID;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE

Thanks,

Bill

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Indexing problem with OFFSET LIMIT
Next
From: Tom Lane
Date:
Subject: Re: Indexing problem with OFFSET LIMIT