write a user-defined function in your hosting code. the only problem is, people that use your database (as opposed to your code), will not be able to use the function. DRH, what about DLL-loadable functions ? this should be easy to arrange, and would be of enormous help. example :
pragma load_Functions "c:\myfuncs.dll" > -----Original Message----- > From: Marcel Strittmatter [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 10:58 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Join function in select statement > > > Hi all > > I like to have a join function that I can use in a select statement > like this: > > select join(name, ',') from people; > > this should produce something like this: > > scott,martin,jones,adams > > It is not possible to use perl or another script language. The only > language I can use is C/C++. Is there a way to create such a function > outside of sqlite, or do I have to extend the sqlite library? > > Regards > Marcel >
