3 ms·
Isn't it table-valued function? IIRC, the SQL standard still doesn't have it but it's almost universally supported extension across vendors.
by summerlight 2y ago
Isn't it table-valued function? IIRC, the SQL standard still doesn't have it but it's almost universally supported extension across vendors.
- zetalyrae 2y agoAt least in Postgres, table-valued functions can't take tables as arguments, only scalars. That's the main difference: functors can not just return tables, but take tables satisfying some interface as arguments. https://www.postgresql.org/docs/7.3/xfunc-tablefunctions.html https://www.postgresql.org/docs/7.3/xfunc-tablefunctions.htm... I thought I had written a footnote or appendix about this but I guess I forgot.
- dagss 2y agoMSSQL can take tables as arguments if they are temporary tables declared to be of a certain type. But that restriction limits their use a lot.