[Pljava-dev] Help with SETOF

From: thhal at mailblocks(dot)com (Thomas Hallgren)
To:
Subject: [Pljava-dev] Help with SETOF
Date: 2004-09-14 18:06:34
Message-ID: 4147332A.2040307@mailblocks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Daniel,
At present, only a set of tuples can be returned and you need to define
a type for the tuple such as:

CREATE TYPE myIntRow AS (myInt integer);

after that, its very similar to the complex return example.

Regards,

Thomas Hallgren

daniel.ovalle wrote:

>I trying to make a function that returns a SETOF int4.
>But i can't do it with the example in the documentation.
>
>Can someone send me a little example with SETOF??
>
>i'm using PostgreSQL 7.4.3 and all the other examples run well.
>
>thanks
>
>Daniel
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>

In response to

Browse pljava-dev by date

  From Date Subject
Next Message daniel.ovalle 2004-09-16 18:11:32 [Pljava-dev] Problem with jdbc driver
Previous Message daniel.ovalle 2004-09-14 17:32:57 [Pljava-dev] Help with SETOF