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.
ya. my mistake.
[snip]
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.
k. this is where i was confused. this is exactly what i wanted/needed
Thanks
Yahoo! Photos Showcase holiday pictures in hardcover
Photo Books. You design it and well bind it!