Problems with operator '%' within a select - Mailing list pgsql-general

From Gabriel Fernandez
Subject Problems with operator '%' within a select
Date
Msg-id 3885CBCE.E29A42CB@unica.edu
Whole thread Raw
Responses RE: [GENERAL] Problems with operator '%' within a select  ("Sean Carmody" <sean@categoricalsolutions.com.au>)
List 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 :-)



pgsql-general by date:

Previous
From: "Nikolay Mijaylov"
Date:
Subject: Re: [SQL] Bug in CEIL?
Next
From: Luis Bezerra
Date:
Subject: (no subject)