Re: plpgsql question

Terminology point: you used the word "aggregate" but the function
below doesn't have an aggregate. Aggregates are functions that
operate on multiple rows, like count() and sum(); substr() doesn't
do that so it's not an aggregate.

1. Create a composite type with the desired columns, declare the
function to return SETOF that type, and declare row to be of
that type.