agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] Help with SETOF
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Help with SETOF
@ 2004-09-14 17:32  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2004-09-14 17:32 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] Help with SETOF
@ 2004-09-14 18:06  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2004-09-14 18:06 UTC (permalink / raw)

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
>  
>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-09-14 18:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-14 17:32 [Pljava-dev] Help with SETOF 
2004-09-14 18:06 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox