The following bug has been logged online: Bug reference: 6236 Logged by: Boris Matkov Email address: bor...@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) ) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
