Craig Bryden wrote:
Hi
Firstly, let me say that I am a newbie to PostgreSQL.
I have written a PL/pgSQL function that will return a set of results. I have
included the code below
***
CREATE TYPE
Here's an example that I butchered to cut it down to size that should
illustrate what you need to do (basically use a LOOP construct)
CREATE TYPE customer.InvoiceItem AS (
WCCustOrderID varchar(16),
OrderDate date,
Currency varchar(3),
TaxCode varchar(3),
Ta
Hi
Firstly, let me say that I am a newbie to PostgreSQL.
I have written a PL/pgSQL function that will return a set of results. I have
included the code below
***
CREATE TYPE pr_SomeFunction_Re
