TRIM Function in Vertica

[geonellickan]

Hi All

I was using a function like this in one of my SQL query [Trim(Column1,'"')]..

But when I did a vertica upgrade, this function is throwing me some error.Could you please let me know what the above function exactly do and also the corresponding function for replacing the same

Thanks

[lveski]

Hi

From documentation:
https://my.vertica.com/docs/7.2.x/HTML/ ... g/TRIM.htm

In previous versions TRIM worked also like you pointed out, but starting from version 7 you should use: Trim('"' from Column1)

Regards,
Lauri