Can scriptella "merge" data?

[Andres Olarte]

Here's my use case, and I'm wondering if scriptella can do this:

I have a table preferences with 4 fields:

id long (PK),

name text,

label text,

value text,

I want to import a row, which means, if it's not there, I insert a new row.  If a row matching the name column (not the PK) is there, I update some of the fields (for example I update label, but not name or value).  In this case I don't know what the id is, nor do I care what it is if I need to import.

Can this be easily achievable, even if it requires a bit of Java coding ?

Thanks

[Fyodor Kupolov]

Hi,

I think upsert or merge into should help in your case http://scriptella.javaforge.com/faq.html#UPSERT 

Regards,

Fyodor

[Andres Olarte]

Thanks, I'm using postgresql, so I had to use a solution a little bit different, as detailed here: http://stackoverflow.com/questions/1109061/insert-on-duplicate-update-postgresql