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)
)