Revision history [back]

When choosing from a function that generates a record containing a variable quantity of columns, it is important to first understand what the function returns and what the columns represent. Once you have a clear understanding of the columns and their corresponding values, you can use the following steps to choose from the function:

1. Identify the specific columns you are interested in.
2. Determine the order in which the columns appear in the record.
3. Use the appropriate syntax to select the desired columns.

For example, if the function returns a record containing columns named "Name", "Age", "Address", and "Phone", and you are interested in selecting only the Name and Age columns, you would use the following syntax:

SELECT Name, Age FROM function_name();

This will return a table with only the Name and Age columns from the record generated by the function.