They are described as scalar, but I think that refers to the return type rather than the arguments.
I'm trying to define one in rust that will provide a TEXT
value derived from other columns in the row, for convenience/readability at point of use, I'd like to call it as select myfunc(mytable) from mytable
rather than explicitly the columns that it derives.
The rusqlite
example simply gets an argument as f64
, so it's not that clear to me how it might be possible to interpret it as a row and retrieve columnar values from within it. Nor have I been able to find examples in other languages.
Is this possible?
This doesn't seem possible.
func(tablename)
syntax that I'm familiar with seems to be PostgreSQL-specific; SQLite supportsfunc(*)
but whenfunc
is user-defined it receives zero arguments, not one (structured) orN
(all columns separately) as I expected.