Awesome, thanks knicely! But, now that I look at the results I kind of like a little white space (maybe just 1 space) between the "$' and the dollar amount. I noticed that the white space increases as I add more "9" characters in the format string than are actually in the number. The output is alway...

Thanks for providing that link, sKwa! I must have searched for the wrong topic. I followed the example and it worked! dbadmin> export LC_ALL=en_US.UTF-8 dbadmin> vsql SET Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate w...

Hi, I'm trying to use the "L" template pattern when using the to_number function but it doesn't seem to work in vsql. dbadmin=> \d salary; List of Fields by Tables Schema | Table | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key --------------+--------+--------+--------------+-...

Cool, thanks! I was able to create a view like you suggested

Thanks for your response, jpcavanaugh. Do you mean that I should not allow the users to read from table and then create a view for each user and control who sees what via the WHERE clause in the view? Is that possible? According to the documentation: If a non-owner runs a SELECT query on the view, t...

Hello, How can I limit the data in a table to a subset of rows for particular users? What I mean is say I have a column called business_unit in a table named org. I only want user A to be able to query rows from the org table where the business_unit is 'Accounting' and I only want user B to be able ...

Thanks for the great post! It's always a hard sale internally when bringing in new technology.