| From: | "handling numeric literals with dots in psql \copy command" <filip(dot)rembialkowski(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4927: psql does "spoil" the query before sending it to server |
| Date: | 2009-07-17 10:31:52 |
| Message-ID: | 200907171031.n6HAVqw3084583@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4927
Logged by: handling numeric literals with dots in psql \copy
command
Email address: filip(dot)rembialkowski(at)gmail(dot)com
PostgreSQL version: 8.4.0
Operating system: Linux
Description: psql does "spoil" the query before sending it to server
Details:
8.4.0:
filip(at)filip=# \copy ( select 1.23::numeric as num ) to 'out.csv' with csv
header
ERROR: syntax error at or near "."
LINE 1: COPY ( select 1 . 23::numeric as num ) TO STDOUT CSV HEADER
^
\copy: ERROR: syntax error at or near "."
LINE 1: COPY ( select 1 . 23::numeric as num ) TO STDOUT CSV HEADER
^
query inside parentheses is OK.
same bug reproduced in 8.3.7
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-07-17 10:36:44 | Re: Huge speed penalty using <>TRUE instead of =FALSE |
| Previous Message | Mikael Krantz | 2009-07-17 09:45:47 | Re: Huge speed penalty using <>TRUE instead of =FALSE |