Is there anything like the `with` statement available in Vertica? (I.e. like subqueries but reusable, avoiding creating temp tables.)

In short I expect the same result as if I loaded it into PostgreSQL - that the first cell contains (in C escaped string literal syntax) "a\"b", and that the second cell contains "c\nd". Also be careful with the "smart" double quotes - if you're just copying from this forum then you need to replace t...

Yes, thank you

I did actually already see that but configuring vertica.ini/VERTICAINI doesn't appear to be doing anything for me.

Edit: Actually it does work. I wasn't exporting my environment variable correctly.

Thanks. I searched the docs but didn't see this. I was also looking under the wrong section (string functions) - for some reason it's considered a mathematical function, alongside sin and sqrt.

Jim, what are you using for your connection string? (See my related question at viewtopic.php?f=21&t=287)

Anyone know why this might be happening? $ cat ~/.odbc.ini [ODBC Data Sources] VerticaDSN = "bigbang" [bigbang] Driver = /opt/vertica/lib64/libverticaodbc.so Database = bigbang Servername = localhost UID = dbadmin PWD = ... Port = 5433 $ LD_LIBRARY_PATH=/opt/vertica/lib64:/opt/vertica/lib64/libverti...