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.

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 we’ll bind it!