lvector_sync_insert

Signature:

CREATE PROCEDURE lvector_sync_insert(table_name LVARCHAR, id BIGINT, embedding lvector_embedding, metadata LVARCHAR);

Purpose: Syncs an inserted Informix row into the LanceDB/lvector backing table.

Example:
BEGIN WORK;
EXECUTE PROCEDURE lvector_sync_insert(
'docs_demo',
1,
lvector_in('[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]'),
'sample document'
);
COMMIT WORK;
Note: Can be called directly or from an insert trigger.