Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3931F475E2E
	for <pgsql-sql@postgresql.org>; Thu, 19 Sep 2002 07:24:14 -0400 (EDT)
Received: from ec.se (bowser.ec.se [213.88.243.12])
	by postgresql.org (Postfix) with ESMTP id 3A9FD475DC8
	for <pgsql-sql@postgresql.org>; Thu, 19 Sep 2002 07:24:13 -0400 (EDT)
Received: from tobbes [62.119.73.5] by ec.se [213.88.243.12]
	with SMTP (MDaemon.v3.5.6.R)
	for <pgsql-sql@postgresql.org>; Thu, 19 Sep 2002 13:23:47 +0200
From: =?iso-8859-1?Q?Thorbj=F6rn_Eriksson?= <thorbjorn.eriksson@ec.se>
To: <_pppp@mail.ru>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Stripping white-space in SELECT statments
Date: Thu, 19 Sep 2002 13:41:25 +0200
Message-ID: <MFEPJLNKECPAPFDGGEIMEENLCBAA.thorbjorn.eriksson@ec.se>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
In-Reply-To: <3D89B025.8070407@mail.ru>
Importance: Normal
X-MDRemoteIP: 62.119.73.5
X-Return-Path: thorbjorn.eriksson@ec.se
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
Reply-To: thorbjorn.eriksson@ec.se
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/214
X-Sequence-Number: 9491

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
that, depending on parameters, creates a variety of SQL statements that in
the end gets executed by PQexec (from libpq i guess).

> -----Ursprungligt meddelande-----
> Från: dima [mailto:_pppp@mail.ru]
> Skickat: den 19 september 2002 13:08
> Till: thorbjorn.eriksson@ec.se
> Kopia: pgsql-sql@postgresql.org
> Ämne: Re: [SQL] Stripping white-space in SELECT statments
>
>
> > 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 system" mean?
>
>