I have a problem in a postgresql query

Question

I have a problem in a postgresql query

Navigation

#1 by (2 votes)

2

I want to do a filtering by ID number but this is a numeric type and the like does not accept it as I can do? the query is this "SELECT * FROM cliente WHERE identif LIKE '_%'"; where identif is of type numeric

sql postgresql

asked by Efrainrodc 21.12.2016 в 01:38

source

1 answer

problems in form with input text and input file VOLEY, sending all the data from a SQLite table

score 2 · Accepted Answer

You can convert the field to a varchar using a CAST to be able to use the operator LIKE :

select *
  from cliente
 where cast(identif as varchar) LIKE '123%'

Demo

Sadly, if you had an index defined for the identif column, the type conversion will prevent the index from being used for better performance.

If performance is a problem, it may be worth changing the type of the column to be alphanumeric at one time. Since it is a cedula, it is not necessary that the field be numeric, since you do not need to perform arithmetic. An alphanumeric field makes more sense in your case.