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.