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
TRIM Function in Vertica
Moderator: NorbertKrupa
Re: TRIM Function in Vertica
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
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