Re: Array vs Temporary table vs Normal Table + truncate at end

2023-09-04 Thread Laurenz Albe
On Mon, 2023-09-04 at 18:42 +0200, Lorusso Domenico wrote: > I prepared a function that build a set of records of type (myComplexType). > > That works, but I've to use this record set in different situations. > > One of them require to scan multiple times the function results: >    1. comparing w

Array vs Temporary table vs Normal Table + truncate at end

2023-09-04 Thread Lorusso Domenico
Hello guys, I prepared a function that build a set of records of type (myComplexType). That works, but I've to use this record set in different situations. One of them require to scan multiple times the function results: 1. comparing with another table (myProducteAttributeTable) to determine