Re: [sqlite] CREATE FUNCTION

2016-08-23 Thread Quan Yong Zhai
>From: Rousselot, Richard A >Sent: 2016年8月23日 22:14 >To: SQLite mailing list >Subject: Re: [sqlite] CREATE FUNCTION >Trust, me if I could remove that dumb message I would. :) There is no such thing as a dumb question. Packing all the core business logic in SQL language has some a

Re: [sqlite] CREATE FUNCTION

2016-08-23 Thread Rousselot, Richard A
@mailinglists.sqlite.org Subject: Re: [sqlite] CREATE FUNCTION Rousselot, Richard A wrote: > This communication is the property of CenturyLink and may contain > confidential or privileged information. So, officially, you did not ask anything? Well, then I'm not going to answer. But it should be men

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Kees Nuyt
On Mon, 22 Aug 2016 18:46:30 +, "Rousselot, Richard A" wrote: > Are there any plans to add a CREATE FUNCTION function for SQLite? > Is this an SQLite4 type thing? Many things you would define a SQL function for can also be accomplished with Common Table

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread J Decker
And every other scripting language you might suggest for the question 'if It did allow creating a function, what flavor of scripting would you like it to be?' has hooks for sqlite ... well except maybe TSQL. (could I script all my database access to a sqlite3 db from SQL Server? Or as the

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Richard Hipp
On 8/22/16, Clemens Ladisch wrote: > > But it should be mentioned that SQLite is an _embedded_ database, i.e., it > is meant to be part of a program written in a 'real' programming language, > so with sqlite3_create_function(), there is no use case for the feature I was about

Re: [sqlite] CREATE FUNCTION

2016-08-22 Thread Clemens Ladisch
Rousselot, Richard A wrote: > This communication is the property of CenturyLink and may contain > confidential or privileged information. So, officially, you did not ask anything? Well, then I'm not going to answer. But it should be mentioned that SQLite is an _embedded_ database, i.e., it is

[sqlite] CREATE FUNCTION

2016-08-22 Thread Rousselot, Richard A
Are there any plans to add a CREATE FUNCTION function for SQLite? Is this an SQLite4 type thing? Something similar PostgreSQL? https://www.postgresql.org/docs/9.5/static/sql-createfunction.html This particular class of function is not mentioned in "SQL Features That SQLite Does Not Implement"