Good morning,

I’ve been all over the web looking for the correct syntax to append a new item to an EMBEDDEDLIST of strings. Ultimately I want to implement this in node, but for now I’d settle for the SQL code. Is there a was to do this without reading and writing the entire list?

Hi @hethcox

did you check this?

You could do it something like this

insert into V set id=1, strings = ["foo"]
update V set strings = strings || "bar" where id = 1

Let me know if this helps


That does help. Thank you.