Hi, SQL Sever has a nice option called "Compatibility level" which lets me run the DB is a mode compatible with SQL Server 2005 (90), SQL Server 2008 (100), or SQL Server 2012 (110). Forgive me if this is too stupid of a question, but is there a similar option is Vertica? So, if I have Vertica 7 ins...

Wow... Duh! I feel dumb. Thanks, Jim. That will work for me.

Hello,

I have some sql code (I did not write it) that uses negative argument values in the left function. But when I run the code I get an error. Like this:
Is there a work around for this?

Thanks!

Howdy! Vertica 7 has the new SHA() security functions. dbadmin=> select sha256('Dog'); sha256 ------------------------------------------------------------------ 0eb129bf94594aaeee66e38361d7be212cd927c3df4dd92e3ded2e0da0c7ad88 (1 row) Is there a way I can covert " 0eb129bf94594aaeee66e38361d7be212cd9...

Hi gurus,

I have a need to add X days to a date but exclude adding any Saturday or Sundays. Today is 11/14/2013. I want to add 12 days. The result I would like is 12/01/2013 (Monday) and not 11/26/2013 (Tuesday).

Is there a simple way to accomplish this in Vertica SQL?

Thanks, scutter! I finally got time to look into this issue again and you were correct! I fixed it.

Hello! How do I fix this this error? I thought we could increase the size of a varchar column in a table? dbadmin=> ALTER table readers.book_digest ALTER COLUMN digest_desc SET DATA TYPE VARCHAR (100); ROLLBACK 2353: Cannot alter type of column "digest_desc" since it is referenced in the segmentatio...