[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Keith Medcalf
> > Le 31 mars 2016 ? 13:32, Keith Medcalf a ?crit : > > > > On the third hand, this could be a case of premature optimization and > the optimal course of action is not to optimize the action before doing > it, but as Nike says, "Just Do It". > > I agree on the generic point, though here the

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Clemens Ladisch
Olivier Mascia wrote: >> Le 31 mars 2016 ? 11:03, Clemens Ladisch a ?crit : >>> I think it is obvious I could build a SQL statement from within the >>> function and execute it. But it sounds costly to involve the parser >>> (yes, it's fast) for that, isn't it? >> >> You can prepare the statement

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Olivier Mascia
Hi, > Le 31 mars 2016 ? 11:03, Clemens Ladisch a ?crit : > >> I think it is obvious I could build a SQL statement from within the >> function and execute it. But it sounds costly to involve the parser >> (yes, it's fast) for that, isn't it? > > You can prepare the statement beforehand. Not

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Hick Gunter
Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Olivier Mascia Gesendet: Mittwoch, 30. M?rz 2016 20:05 An: SQLite mailing list Betreff: [sqlite] Calling some predefined SQL function from another custom SQL

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Clemens Ladisch
Olivier Mascia wrote: > Writing a scalar SQL function, is there a C-level way to call some > other scalar SQL function? The only way is to build an SQL statement from within the function and execute it. > I think it is obvious I could build a SQL statement from within the > function and execute

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Scott Hess
On Thu, Mar 31, 2016 at 6:39 AM, Olivier Mascia wrote: > > Le 31 mars 2016 ? 11:03, Clemens Ladisch a ?crit : > >> I think it is obvious I could build a SQL statement from within the > >> function and execute it. But it sounds costly to involve the parser > >> (yes, it's fast) for that, isn't

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-31 Thread Keith Medcalf
users- > bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Thursday, 31 March, 2016 03:04 > To: SQLite mailing list > Subject: Re: [sqlite] Calling some predefined SQL function from another > custom SQL function? > > Olivier Mascia wrote: > > Writin

[sqlite] Calling some predefined SQL function from another custom SQL function?

2016-03-30 Thread Olivier Mascia
Hello, Writing a scalar SQL function, is there a C-level way to call some other scalar SQL function? For instance, writing some specialized date_xyz(), could it be possible to prepare some arguments and call strftime()? I see in the code that strftimeFunc() is the implementation for the