[sqlite] field name in UDF

2015-11-09 Thread Nelson, Erik - 2
Stephan Beal Sent: Saturday, November 07, 2015 3:54 AM > On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 < > erik.l.nelson at bankofamerica.com> wrote: > > > I have a user-defined function something like > > > > void quarter_sqlite3(sqlite3_context *context, int argc, > sqlite3_value > >

[sqlite] field name in UDF

2015-11-07 Thread Stephan Beal
On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 < erik.l.nelson at bankofamerica.com> wrote: > I have a user-defined function something like > > void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value > **argv); > > for each sqlite3_value being passed in, it would sometimes be

[sqlite] field name in UDF

2015-11-06 Thread Stephan Beal
On Fri, Nov 6, 2015 at 7:04 PM, Nelson, Erik - 2 < erik.l.nelson at bankofamerica.com> wrote: > select quarter(t1.a) from t1 ; > > I might hope to get 'a' or 't1.a'. Any ideas? > UDFs (in any scripting environment) don't get that level of info. They only get passed the values resolved by

[sqlite] field name in UDF

2015-11-06 Thread Stephan Beal
On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 < erik.l.nelson at bankofamerica.com> wrote: > I have a user-defined function something like > > void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value > **argv); > > for each sqlite3_value being passed in, it would sometimes be

[sqlite] field name in UDF

2015-11-06 Thread Nelson, Erik - 2
Stephan Beal wrote on Friday, November 06, 2015 1:00 PM > On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 wrote: > > > I have a user-defined function something like > > > > void quarter_sqlite3(sqlite3_context *context, int argc, > sqlite3_value > > **argv); > > > > for each sqlite3_value being

[sqlite] field name in UDF

2015-11-06 Thread Nelson, Erik - 2
I have a user-defined function something like void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value **argv); for each sqlite3_value being passed in, it would sometimes be helpful to have the associated field (if any) that the value is associated with. Is there any way to

[sqlite] field name in UDF

2015-11-06 Thread Igor Tandetnik
On 11/6/2015 12:50 PM, Nelson, Erik - 2 wrote: > I have a user-defined function something like > > void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value > **argv); > > for each sqlite3_value being passed in, it would sometimes be helpful to have > the associated field (if any)