Re: Queries inside UDF

2005-03-25 Thread sguazt sguazt
From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To: "'mysql@lists.mysql.com '" Subject: Re: Queries inside UDF Date: Mon, 21 Mar 2005 11:05:39 + sguazt sguazt wrote: Hi! From: Philippe Poelvoorde <[EMAIL PRO

Re: Queries inside UDF

2005-03-17 Thread sguazt sguazt
Hi! From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To: mysql@lists.mysql.com Subject: Re: Queries inside UDF Date: Thu, 17 Mar 2005 08:22:46 + ... You can actually access a DB within a UDF, but you should do the same than when you're using the C api of mysq

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
ike UDF_INIT* initid) to access to current DBMS connection object. I this is true ... what a pity! I hope MySQL staff will think to extend UDF to include this feature unless there're hidden trickly I don't see. -- Marco From: [EMAIL PROTECTED] To: "sguazt sguazt" &

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
From: [EMAIL PROTECTED] To: "sguazt sguazt" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: RE: Queries inside UDF Date: Wed, 16 Mar 2005 12:37:59 -0500 I can almost follow the logic of your pseudocode. Can you explain "what" it is you are tryi

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
Hi! From: Tom Crimmins <[EMAIL PROTECTED]> To: sguazt sguazt <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: RE: Queries inside UDF Date: Wed, 16 Mar 2005 10:09:16 -0600 ... Can you explain exactly what you are using this for? What benefit does this provide over just executi

Queries inside UDF

2005-03-16 Thread sguazt sguazt
Hi folks! (I hope this is the right list ... if not please tell me where I can submit this post) I would like to create a MySQL UDF (i.e. User Defined Function) that embeds a query; for instance, suppose the UDF is named foobar: mysql> SELECT foobar(); When foobar function receives the control