Hi foo,

The issue is occurring in version 5.0.11 of the Vertica database.

I'll open a ticket and let everyone know what I find out!

Thanks!

Wow! That makes more sense! Thank you.

Hi guys, I'm getting a weird error when trying to convert an integer sum to a float via the CAST command. This works: dbadmin=> SELECT d.dname, e.ename, e.sal, dbadmin-> round(sal / sum(cast(e.sal as float)) OVER (PARTITION BY e.dname),2) sal_dept_ratio dbadmin-> FROM emp e, dept d dbadmin-> WHERE e...

Thanks, skwa! That's exactly what I needed!

Hi, I'm converting some Oracle database code over to Vertica and was wondering if there is a conditional mutli-table insert option in Vertica? This is some sample code from Oracle: INSERT ALL WHEN 1 = 1 THEN INTO appt_hist VALUES (appt_id, app_date, app_status) WHEN app_status = 'CANCL' THEN INTO ap...

Hi, Is there a way that I can display a NULL result from a query as some sort of alternate text in vsql? Oracle has a feature in SQL*Plus where I type SET NULL = 'N/A' and from that point on all NULLs are replaced with the text 'N/A'. Example in Oracle: SQL> SET NULL = 'N/A' SQL> SELECT NULL mycol F...

Good morning,

Is there a way that I can display a number in words in Vertica using SQL?

Examples...

10 as Ten
800 as Eight Hundred
1700 as One Thousand Seven Hundred
1250 as One Thousand Two Hundred Fifty

Thank you.