Hi Guys,
Please help me, how to treat ' in vertica in clause
in Mysql i use \ to manage or control ' please suggest
for example in mysql
SELECT 'xlstime\'s';
please suggest in Vertica
How to treat ' in Vertica
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to treat ' in Vertica
Hi,
The easiest way to deal with an apostrophe "'" in text is to simply use double apostrophes "''".
Example:
Single apostrophe:
Double apostrophes:
The easiest way to deal with an apostrophe "'" in text is to simply use double apostrophes "''".
Example:
Single apostrophe:
Code: Select all
dbadmin=> SELECT 'xlstime\'s';
dbadmin'>
Code: Select all
dbadmin=> SELECT 'xlstime\''s';
?column?
------------
xlstime\'s
(1 row)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.