Problems with operator '%' within a select

From: Gabriel Fernandez <gabi(at)unica(dot)edu>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Problems with operator '%' within a select
Date: 2000-01-19 14:35:58
Message-ID: 3885CBCE.E29A42CB@unica.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi !

I've just had some problems using the operator '%' within a select.
This is an example:

"select codigo from codis where codigo like '%3' "

And i've found that all the rows which contains more than one three
won't be selected.
(For example: values 'a34ree3', '34fg3')

It seems as if you put only one character with '%' it will select only
the rows wich contain only one time this character.

Am I wrong ?

Gabi :-)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-01-19 15:02:13 Re: [SQL] Bug in CEIL?
Previous Message Nikolay Mijaylov 2000-01-19 14:05:33 Re: [SQL] Bug in CEIL?