=?iso-8859-1?Q?Thorbj=F6rn_Eriksson?= <[EMAIL PROTECTED]> writes:
> Thank's Tom Lane & Stephan Szabo for pointing out the problem to me.
> After some testing it turned out that the swedish locale, 'sv_SE', doesn't
> handle sorting spaces as expected, which probably made the SELECT fail. On
> the o
L PROTECTED]
> Kopia: [EMAIL PROTECTED]
> Ämne: Re: [SQL] Stripping white-space in SELECT statments
>
>
> =?iso-8859-1?Q?Thorbj=F6rn_Eriksson?= <[EMAIL PROTECTED]> writes:
> > I've encountered a strange behavior in postgres 7.2.1 regarding how psql
> > handles
On Thursday 19 September 2002 13:41, Thorbjörn Eriksson wrote:
> By "our system" I mean the software that uses the database. It is a quit
> old software written in C that has been ported a couple of times to
> different *NIX platforms using different DBMS's. It uses in-house developed
> functions
--On jeudi 19 septembre 2002 13:20 +0200 Thorbjörn Eriksson
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've encountered a strange behavior in postgres 7.2.1 regarding how psql
> handles strings ending with space characters.
>
> If I want to search for records where the first column (artnrgrpmtrl
On Thu, 19 Sep 2002, [iso-8859-1] Thorbjörn Eriksson wrote:
> Hello,
>
> I've encountered a strange behavior in postgres 7.2.1 regarding how psql
> handles strings ending with space characters.
>
What locale did you initdb with? Some locales on some systems have
behavior like that. To test, y
=?iso-8859-1?Q?Thorbj=F6rn_Eriksson?= <[EMAIL PROTECTED]> writes:
> I've encountered a strange behavior in postgres 7.2.1 regarding how psql
> handles strings ending with space characters.
Perhaps you are running in a non-C locale? A lot of locales have
sorting rules that are pretty weird about
SQL statements that in
the end gets executed by PQexec (from libpq i guess).
> -Ursprungligt meddelande-
> Från: dima [mailto:[EMAIL PROTECTED]]
> Skickat: den 19 september 2002 13:08
> Till: [EMAIL PROTECTED]
> Kopia: [EMAIL PROTECTED]
> Ämne: Re: [SQL] Stripping white-space
> If I want to search for records where the first column (artnrgrpmtrln_1)
> begins with
> '201901 ', our system that uses the database creates the following SQL
> statement:
>
> select artnrgrpmtrln_1 from sr where (artnrgrpmtrln_1>='201901 ' and
> artnrgrpmtrln_1<='201901 ÿ'
what does "our s
Hello,
I've encountered a strange behavior in postgres 7.2.1 regarding how psql
handles strings ending with space characters.
If I want to search for records where the first column (artnrgrpmtrln_1)
begins with
'201901 ', our system that uses the database creates the following SQL
statement:
s