select field text separated by comma return lines

Question

Navigation

#1 by (1 votes)

1

Does anyone know how it is possible in postgresql to get a value inside a field of type TEXT that has comma-separated records to use in WHERE ?

Example of values in the field (35693,35694,35695,35696,35697,35698,35699,713)

Example

Select * from tabela where id = '35693'

But the value in where is inside a comma-separated string, like breaking and comparing?

postgresql

asked by anonymous 26.02.2015 / 15:58

1 answer

Can not connect to MySQL server on 'IP (4) Calculate remainder with 2 numbers BigInteger

score 1 · Answer 1

1

I was able to resolve using:

UNNEST(ARRAY[string_to_array(campo_pesquizar, ',')])::INT

26.02.2015 / 17:18