Иван Гладуш
Reputation: 642
How to create table (set returning) function in redshift?
I tried to create a table (set returning) function in redshift but failed.
Because redshift only supports scalar function (documentation). Is it true? Can I create table functions?
Upvotes: 1
Views: 744
Answers (1)
user330315
Reputation:
The simple answer: no you can not create table functions ("set returning functions) as you can do in Postgres.
The section Unsupported PostgreSQL Features in the Redshift manual explicitly lists "Table functions".
Upvotes: 3
Related Questions
- Return a table from a user defined function in Redshift
- Using sql function generate_series() in redshift
- How to convert row to compute column value in SQL
- How to use variables inside functions in Redshift?
- How to create a table within a database in Redshift?
- Create table as in Redshift defining primary key
- Redshift: How to Create a Function which Uses a Lookup Table
- How to put redshift query in function?
- How do I create row numbers in Redshift?
- How to use function column in select query