That's a much better suggestion

Hi, I do not think that Vertica has the ROLLUP function, but you can fake it so that a query's output would look like Oracle's output: Example: dbadmin=> select * from region; region -------- east north south west (4 rows) dbadmin=> select * from sale; year | month | region | tot_sales ------+------...

insert into ColorsRand select subquery.colour from (select random() + randomint(100), colour from Colors order by 1) as subquery limit 3; If you need to do this on a larger scale, you can change the subquery just a tad so that you won't need to call the random() function... insert into ColorsRand s...

Piglet,

A "General" forum has been added under the "General" forum category.

viewforum.php?f=60

Thanks for the suggestion!

You can also use the ADD_MONTHS() built in function to add years... dbadmin=> SELECT add_months(DATE '2012-06-06', 12) add_1_year, dbadmin-> add_months(DATE '2012-06-06', 24) add_2_years, dbadmin-> add_months(DATE '2012-06-06', 6) add_half_year, dbadmin-> add_months(DATE '2012-06-06', 30) add_2_and_...

Great news, Vertica 6.0 gives us the ability to change a table column's data type... Here's an excerpt from the New Feature's Guide: Using new parameters in the ALTER TABLE statement, you can now perform the following operations: Change, reorganize, and remove tble partitions Add table columns with ...

Great news, Vertica 6.0 supports a DROP COLUMN feature: Here's an excerpt from the New Feature's Guide: Using new parameters in the ALTER TABLE statement, you can now perform the following operations: Change, reorganize, and remove tble partitions Add table columns with a default derived expression ...