Tag: set-returning-functions

Found 54 results for 'set-returning-functions'.

1) postgresql - Difference between unnest() in SELECT vs unnest() in FROM on Postgres
2) postgresql - C Extension: Is it faster to return a set with ValuePerCall or Materialize mode?
3) postgresql - Unnest multiple arrays into rows
4) postgresql - Selecting only overlapping elements from array of ranges
5) postgresql - Select into specific array positions with array_agg()?
6) postgresql - Extract and combine multiple values from a jsonb column
7) sql-server - Efficiency of Scalar UDF vs TVF
8) postgresql - Should I write a scalar function or a setof returning function for an INSERT/UPDATE/DELETE which can return at most one row?
9) postgresql - SELECT rows from table one by one, comparing one column values with values in an array
10) postgresql - How do I optimize my transaction level running balances cartesian join?
11) postgresql - Split up interval into year slices
12) sql - PostgreSQL unnest() with element number
13) postgresql - Concatenation of setof type or setof record
14) postgresql - Slow left join lateral in subquery
15) postgresql - How to (optimally) get random sample of (a.id, b.id) pairs from two tables (a, b)?
16) sql-server - SQL Profiler shows multiple calls for one TVF
17) postgresql - Error: set_valued function called in context that cannot accept a set. What is it about?
18) postgresql - PostgreSQL - Return type and EXECUTE QUERY
19) sql - Split column into multiple rows in Postgres
20) sql - Return list with dates within a specified range from a single query
21) sql-server - Audit use of CLR Table-valued function
22) postgresql - Need for recursive lookup, stuck in query design
23) sql-server - Should I add set nocount for functions?
24) postgresql - Postgres - Return default value if regex match fails
25) sql-server - How to recompile all stored procedures and table valued functions in SQL Server database?
26) postgresql - Surprising results from assigning multiple variables in FOR loop
27) postgresql - Function execute query, manipulates result and then return the same result
28) postgresql - RETURN NEXT in Postgres Function
29) sql-server - Does SQL Server cache the result of a multi-statement table-valued function?
30) sql - What is the expected behaviour for multiple set-returning functions in SELECT clause?
31) postgresql - Return previous running total when value is null in a time series
32) postgresql - jsonb_array_elements() in the select seems to turn a left join into an inner join
33) postgresql - Array integer[]: how to get all distinct values in a table and count them?
34) postgresql - Give alias / column definition list to ROWS FROM()
35) sql - Split column into multiple rows in Postgres
36) postgresql - Understanding joined set-returning functions in the FROM list
37) postgresql - Generate multiple running totals with GROUP BY day
38) postgresql - Filling in missing dates in record set from generate_series()
39) postgresql - How do I optimize my transaction level running balances cartesian join?
40) postgresql - How to use RETURNS TABLE with an existing table in PostgreSQL?
41) arrays - Unnest multiple arrays in parallel
42) sql-server - T-SQL Daylight Saving lookup table - poorly performing table-valued function
43) sql-server - Multi-statement TVF vs Inline TVF Performance
44) postgresql - How to insert a record returned by a function into a table
45) postgresql - How to fan out rows with a specified range of values?
46) postgresql - returning set of records in stored procedure
47) sql-server - Check for duplicate data from called functions
48) postgresql - How do you declare a set-returning-function to only be allowed in the FROM clause?
49) postgresql - Cross-product between table column and input values
50) sql-server - How to return several arrays of doubles as a table in C# SQLCLR function