Re: Stripping white-space in SELECT statments

From: dima <_pppp(at)mail(dot)ru>
To: thorbjorn(dot)eriksson(at)ec(dot)se
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Stripping white-space in SELECT statments
Date: 2002-09-19 11:08:21
Message-ID: 3D89B025.8070407@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thorbjörn Eriksson 2002-09-19 11:20:38 Stripping white-space in SELECT statments
Previous Message Rajesh Kumar Mallah. 2002-09-19 07:06:11 Re: Index usage on date feild , differences in '>' and '>=' and between