> > 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
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
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
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
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
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
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
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
8 matches
Mail list logo