The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
updates with aggregates
I need to do an update with an aggregate, and vsql is having a problem: eg: update tempdb.table1 set total_units = (select sum (sales_units) from tempdb.table2 m2 where tempdb.table1.sales_event_id = md2.sales_event_id and m2.full_dt <= table1.full_dt ); any ideas? thanks