Re: [BUGS] BUG #6236: Query execution bug

2011-09-30 Thread Tom Lane
"Boris Matkov" writes: > 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: > --

[BUGS] BUG #6236: Query execution bug

2011-09-30 Thread Boris Matkov
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 DISTIN