| From: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
|---|---|
| To: | handling numeric literals with dots in psql copy command <filip(dot)rembialkowski(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4927: psql does "spoil" the query before sending it to server |
| Date: | 2009-07-17 19:50:02 |
| Message-ID: | 4A60D5EA.5060308@timbira.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
handling numeric literals with dots in psql copy command escreveu:
> 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
>
Thanks for your report.
Why are we analysing the query there? One possible fix is to remove the '.' as
delimiter in strtokx(). The trivial patch is attached.
--
Euler Taveira de Oliveira
http://www.timbira.com/
| Attachment | Content-Type | Size |
|---|---|---|
| psql | text/plain | 672 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-17 21:26:04 | Re: BUG #4927: psql does "spoil" the query before sending it to server |
| Previous Message | Tom Lane | 2009-07-17 18:36:41 | Re: BUG #4926: too few pathkeys for mergeclauses |