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 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 retrieve that? > > > > UDFs receive expanded/evaluated values, not fields: > > select quarter(t1.a+t2.a+t3.a+3.0) from t1, t2, t3...; > > what field would you expect to get there?
Hence the "(if any)". For select quarter(t1.a) from t1 .... ; I might hope to get 'a' or 't1.a'. Any ideas? ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.
