You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm getting this expression (note the replace chars near E '"\n\r"+', '', 'g') )
SELECT*FROM"condition_tests"WHERE"field_varchar_nullable"IS NOT NULLAND unaccent(
TRIM(
regexp_replace(field_varchar_nullable, E '"\\n\\r"+', '', 'g')
)
) ilike '%'|| unaccent('le dijo')
If you compare results using MSSql and postgresql factory are different on chars "[" and "]".
How can I escape or acomplish the statement: E'[\n\r]+'
Thanks
UPDATE: note the space after "E" on expression => E '"\n\r"+', '', 'g') this is addded qhen symbol "[" is replaced
When I've try to escape the symbols with "" that space continues appearing in consequence SQL does not work
The text was updated successfully, but these errors were encountered:
In order to get this sentence using WhereRaw:
I've used this string as raw sentence:
I'm getting this expression (note the replace chars near E '"\n\r"+', '', 'g') )
If you compare results using MSSql and postgresql factory are different on chars "[" and "]".
How can I escape or acomplish the statement: E'[\n\r]+'
Thanks
UPDATE: note the space after "E" on expression => E '"\n\r"+', '', 'g') this is addded qhen symbol "[" is replaced
When I've try to escape the symbols with "" that space continues appearing in consequence SQL does not work
The text was updated successfully, but these errors were encountered: