How to get dataset from psql procedure?

Question

PostgreSQL

The question is, how do I give the combined data at the psql function level. For example, I want to select a couple of fields from one table + another field that is the result of count () of another table and return the whole thing.

Answer 1

No problem, return an array, ROWTYPE, RECORD, or arbitrary type from a stored procedure. If there are not many returned values, then OUT parameters can also be used.