i need a trigger to create and insert a new guid into a table, but apparently there is no built-in function for creating guids in sqlite.

i can create the guid in C using uuid_generate() and then uuid_unparse() to get it into a string format.

but how can i call that c code from a trigger?

my understanding was that sqlite allows for user functions written in C and used from within your sql code, but i forget where i saw that and i'm so far unable to find in the docs where it shows how this is done.

anyone done this before?

- chase




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to