Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1600C476B82
	for <pgsql-sql@postgresql.org>; Thu, 19 Sep 2002 07:08:29 -0400 (EDT)
Received: from mx9.mail.ru (mx9.mail.ru [194.67.57.19])
	by postgresql.org (Postfix) with ESMTP id 3240A476B9D
	for <pgsql-sql@postgresql.org>; Thu, 19 Sep 2002 07:08:28 -0400 (EDT)
Received: from drweb by mx9.mail.ru with drweb-scanned (Exim MX.9)
	id 17rzAc-0006K3-00; Thu, 19 Sep 2002 15:08:30 +0400
Received: from [213.128.193.142] (helo=mail.ru)
	by mx9.mail.ru with esmtp (Exim SMTP.9)
	id 17rzAb-0006B2-00; Thu, 19 Sep 2002 15:08:29 +0400
Message-ID: <3D89B025.8070407@mail.ru>
Date: Thu, 19 Sep 2002 15:08:21 +0400
From: dima <_pppp@mail.ru>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0.0) Gecko/20020816
X-Accept-Language: ru, en-us, en
MIME-Version: 1.0
To: thorbjorn.eriksson@ec.se
Cc: pgsql-sql@postgresql.org
Subject: Re: Stripping white-space in SELECT statments
References: <MFEPJLNKECPAPFDGGEIMEENJCBAA.thorbjorn.eriksson@ec.se>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Envelope-To: thorbjorn.eriksson@ec.se,
 pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/213
X-Sequence-Number: 9490

> 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?