Re: [sqlite] Join function in select statement

2004-11-02 Thread Dan Keeley
Loading shared libraries is easy enough on windows and Linux, but throw AIX and HPUX and Solaris into the mix and suddenly things become more complicated. SQLite is a cross-platform library. It has to work on more than just windows. Really? Both these platforms support shared libraries - I use t

RE: [sqlite] Join function in select statement

2004-11-02 Thread CARIOTOGLOU MIKE
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 4:49 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Join function in select statement > > > CARIOTOGLOU MIKE wrote: > > Why not provide some extra

Re: [sqlite] Join function in select statement

2004-11-02 Thread D. Richard Hipp
CARIOTOGLOU MIKE wrote: Why not provide some extra functionality on one platform ? Because that's not what SQLite does. SQLite works the same on all platforms. Note also that were this policy to change and SQLite were allowed to have extra features on selected platforms, it is most likely that U

Re: [sqlite] Join function in select statement

2004-11-02 Thread Gerhard Haering
On Tue, Nov 02, 2004 at 04:36:41PM +0200, CARIOTOGLOU MIKE wrote: > [user-defined functions loadable through shared libraries] > true. OTOH, since, as you say, it *is* simple, why not provide some extra > functionality on one platform ? it does not affect other platforms, and it > is s nice to

RE: [sqlite] Join function in select statement

2004-11-02 Thread CARIOTOGLOU MIKE
mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 3:44 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Join function in select statement > > > CARIOTOGLOU MIKE wrote: > > write a user-defined function in your hosting code. the > only problem is, >

Re: [sqlite] Join function in select statement

2004-11-02 Thread D. Richard Hipp
CARIOTOGLOU MIKE wrote: 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. exa

RE: [sqlite] Join function in select statement

2004-11-02 Thread CARIOTOGLOU MIKE
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_Func

Re: [sqlite] Join function in select statement

2004-11-02 Thread Eric Bohlman
Marcel Strittmatter wrote: 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 ca