Re: Strange Result with char concatenation in query. - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Strange Result with char concatenation in query.
Date
Msg-id 2r95fu4tqeho7jnkmdljimo61jtj6v50lv@4ax.com
Whole thread Raw
In response to Strange Result with char concatenation in query.  ("mathieu.chappuis@msg-software.com" <mathieu.chappuis@msg-software.com>)
List pgsql-general
On Fri, 24 May 2002 16:09:54 +0200,
"mathieu.chappuis@msg-software.com"
<mathieu.chappuis@msg-software.com> wrote:
>Hello,
>
>A short example, is IMHO more explicit :
>
>% cat file.csv
>1,100/100
>2,100/100
>3,200/200

I bet, your input lines end with <CR>/<LF> (carriage return/linefeed).
On COPY FROM the <CR> is stored as the last character of chartst.

>test_db=> SELECT '+'||numtst||'+' AS "numtst", '*'||chartst||'-' AS "chartst"  FROM test;
> numtst | chartst
>--------+------------
>-+2+    | *100/100

Your terminal gets
 +2+    | *100/100<CR>-

<CR> sends the cursor to the start of the line, so you see the - in
front of the rest.  Just to illustrate this, try

SELECT '+'||numtst||'+' AS "numtst", '*'||chartst||'-abc-' AS
"chartst"  FROM test;

and you will get
 numtst | chartst
--------+------------
-abc-   | *100/100

Servus
 Manfred

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange Result with char concatenation in query.
Next
From: Larry Rosenman
Date:
Subject: Re: Altering existing table to be WITHOUT OIDs