findepi commented on issue #12272:
URL: https://github.com/apache/datafusion/issues/12272#issuecomment-2329530054
> What do you mean `SQL type`?
e.g. `varchar(n)`, `bigint`. As in `SELECT CAST('123' AS bigint)` which is a
valid expression accepted by DF.
> Do you have a example of your function?
- PostgreSQL `pg_typeof`
https://www.postgresql.org/docs/16/functions-info.html#pg_typeof:~:text=pg_typeof%20(%20%22any%22%20)%20%E2%86%92%20regtype
- Trino `typeof`
https://trino.io/docs/current/functions/conversion.html#typeof
- Snowflake `SYSTEM$TYPEOF`
https://docs.snowflake.com/en/sql-reference/functions/system_typeof
- except here the result is not usable in a CAST, it's more like our
`arrow_typeof`
- DuckDB `pg_typeof`
https://duckdb.org/docs/sql/functions/utility.html#pg_typeofexpression
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
