3
I saw this line of code in some examples:
SELECT * from produto where nome ~*'$texto_pesquisado';"
But I don’t know what the function of ~*
, I found no explanation. What is it for?
3
I saw this line of code in some examples:
SELECT * from produto where nome ~*'$texto_pesquisado';"
But I don’t know what the function of ~*
, I found no explanation. What is it for?
3
The ~*
is a Postgresql regex operator that does not differentiate case from case, as you can see in documentation.
So, in your example, you’re looking for a name that doesn’t matter if it starts out as uppercase or lowercase.
2
In Postgresql the operator ~*
serves to search for regular expressions containing the string passed as a search parameter, without differentiating between uppercase and lowercase characters, i.e., in case sensitive.
In this case, your query SELECT * from produto where nome ~*'$texto_pesquisado';"
, will return all lines that contain in your name the expression '$texto_pesquisado'
, no matter if it is capitalized or minuscula.
You can see more about here https://www.postgresql.org/docs/9.3/functions-matching.html.
Thanks for the clarification.
Browser other questions tagged sql database postgresql
You are not signed in. Login or sign up in order to post.
Thanks for the clarification.
– robs