BUG #6236: Query execution bug

The following bug has been logged online:

Bug reference: 6236
Logged by: Boris Matkov
Email address: borism(at)devart(dot)com
PostgreSQL version: 9.0.0.1
Operating system: Windows
Description: Query execution bug
Details:

INSERT INTO btest0 (id, name) VALUES ((SELECT DISTINCT id FROM btest0 WHERE
name = $1 LIMIT 1), $1) - was executed successfully

INSERT INTO btest0 (name,id) VALUES ($1, (SELECT DISTINCT id FROM btest0
WHERE name = $1 LIMIT 1)) - I got error:
---------------------------
inconsistent types deduced for parameter $1
---------------------------

Script for the btest0 table creating:

CREATE TABLE btest0
(
id integer NOT NULL,
name character varying(50) NOT NULL,
value double precision,
CONSTRAINT pk_btest0 PRIMARY KEY (id)
)