Re: [GENERAL] plpgsql question

[Matthew Peter]

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!