On 6/14/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
You can't infer a function's return type from its arguments. Take the hypothetical function FOO(x). If I pass it a number, it will return the number spelled out as TEXT, but if I pass it a BLOB it will return its length*PI as a FLOAT.
Would it be reasonable to have: SELECT myfunc(x, y, z); have an undefined return type, while: SELECT CAST(myfunc(x, y, z) AS INTEGER); would return a well-defined return type? After all, in SQLite you can't infer a column's type, either, you can only infer how the column is declared. What it actually contains could be anything at all. -scott ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
