Me again
Can we use a sequence in the MERGE command? I read the documentation, but I'm not sure I completely follow the explanation. It seems like it says we can if the table's column default is the next value from the sequence, but when I tried it, I get an error about not being able to use a sequence or identity.
MERGE Command - Using a sequence
Moderator: NorbertKrupa
MERGE Command - Using a sequence
Thanks,
Juliette
Juliette
Re: MERGE Command - Using a sequence
Hi!
mean - no sequence as column in query at all.[...]Vertica can perform a MERGE operation if you omit the sequence from the query[...]
means that column C1 will insert or update it value with MERGE implicitly, i.e. from DEFAULT definition.[...]if you define column c1 as follows, Vertica can do a merge.
CREATE TABLE t (c1 INT DEFAULT s.nextval, c2 INT);
[...]