From: Thorbjörn 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> (raw)
In-Reply-To: <3D89B025.8070407@mail.ru>
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?
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: thorbjorn.eriksson@ec.se, _pppp@mail.ru
Subject: Re: Stripping white-space in SELECT statments
In-Reply-To: <MFEPJLNKECPAPFDGGEIMEENLCBAA.thorbjorn.eriksson@ec.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox