subject:"Re\: \[GENERAL\] PL\/pgSQL functions and RETURN NEXT"

Re: [GENERAL] PL/pgSQL functions and RETURN NEXT

2005-01-30 Thread Sven Willenberger

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

Re: [GENERAL] PL/pgSQL functions and RETURN NEXT

2005-01-30 Thread John Sidney-Woollett

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