Hi, Thanks for your respond, I want to edit the data in the table. I can do it by this Updare statement: update Table_name set column_name=10 where.. But I want to be able to update manually while I'm looking the data In Oracle I used to use Toad Application, there when you write the select statemen...

Hi all,
Is somebody know how can I edit some query result easily without using Update command?

In oracle I use it:
select r.*,rowid from dw_articles r where..


Thanks a lot!

Hi guys, I'm trying to use analytic function and use the current value. For Example: I'm trying to calculate for each day, how many people were charged on the same day payment based on the day number of the month they were ask for the service. (the day of payment cased on the day they asked for the ...

Hi sKwa,
I use Vertica docs but Unfortunately I did not found there the solution for this case,
If you know some good Vertica docs I will be glad to get a link

Thanks,
Sapir

Thanks knicely87! Love this solution

Hi, First thnaks :) What I still don't know is how can I add to this query filter on the table witch I want to update. I want to do the update action only for some rows. In posrgress or oracle you may add this filter: .. WHEN MATCHED AND (test_merge.id <100) THEN .. In Vertica I don't know how to do...

Hi Guys, How can I use merge and filter on the first table? in postgres this is the syntax: MERGE INTO target [AS correlation-name] USING [table-ref | subquery] ON <search-condition> [WHEN MATCHED THEN MergeUpdate WHERE <where-clause> [/color]DELETE WHERE <where-clause>] [WHEN NOT MATCHED THEN Merge...