Postgres Pro
Downloads
Home   >   mailing lists

Re: How to concat strings so that trailing spaces remain - Mailing list pgsql-general

From Tom Lane
Subject Re: How to concat strings so that trailing spaces remain
Date
Msg-id 16761.1143745211@sss.pgh.pa.us
Whole thread Raw
In response to How to concat strings so that trailing spaces remain  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
"Andrus" <eetasoft@online.ee> writes:
> I have where clause where all fields are CHAR(10) type and may have trailing
> spaces.
> ...
> Correct result is produced if || operator does not remove trailing spaces.

If you think that trailing spaces are significant data, you should
probably be using VARCHAR not CHAR datatype.

            regards, tom lane

pgsql-general by date:

Previous
From: Don Y
Date:
Subject: User defined data type
Next
From: Martijn van Oosterhout
Date:
Subject: Re: User defined data type