Re: plpgsql question - Mailing list pgsql-general

From Matthew Peter
Subject Re: plpgsql question
Date
Msg-id 20060110034201.37205.qmail@web35204.mail.mud.yahoo.com
Whole thread Raw
In response to Re: plpgsql question  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general

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!

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: calling stored procedure with array paramenter (for psql)
Next
From: Matthew Peter
Date:
Subject: Re: Passing a list of values to a function