Caetano Traina Junior schrieb am 18.07.2021 um 15:19:>
>> Em sáb., 17 de jul. de 2021 às 05:33, Thomas Kellerer <shammat@gmx.net <mailto:shammat@gmx.net>> escreveu:
>> And before you ask: it's not really possible to make this dynamic, so that the number
>> of columns "automagically" increases when you have more fruits. One fundamental
>> restriction of the SQL language is that the number and types of all columns
>> must be known to the database when the query is parsed. It can't change
>> the columns as a result of the query itself.
> Nonetheless, it is always possible to write a dynamic SQL (and best
> yet, inside a plpgsql function) to "automagically handle more
> fruits..."
Even if you create a function that uses dynamic SQL, you still have to
specify each output column "manually" when calling the function.
So that doesn't really buy you anything.