Re: [BUGS] BUG #6529: Invalid numeric input syntax for 'select into' queries

2012-03-21 Thread Tom Lane
neh...@gmail.com writes: > [ test_bug_type is composite ] > $$DECLARE > test_bug_var test_bug_type; > BEGIN > SELECT test_field INTO test_bug_var FROM test_bug_table LIMIT 1; > --ERROR: invalid input syntax for type numeric: "(15.50,USD)" > --CONTEXT: PL/pgSQL function "inline_code_bl

[BUGS] BUG #6529: Invalid numeric input syntax for 'select into' queries

2012-03-13 Thread nehxby
The following bug has been logged on the website: Bug reference: 6529 Logged by: Maxim Turchin Email address: neh...@gmail.com PostgreSQL version: 9.1.3 Operating system: Ubuntu 11.10 Description: CREATE TYPE test_bug_type AS (value numeric(15,2), curr