BUG #6236: Query execution bug

The following bug has been logged online:

Bug reference:      6236
Logged by:          Boris Matkov
Email address:      borism@devart.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)
)