View Single Post

   
  #5 (permalink)  
Old 04-11-2008, 06:53 AM
Pavel Stehule
 
Posts: n/a
Default Re: Returning multiple result sets


>
>Consider:
>
>create function a(anyrecord) returns anyrecord;
>create function b(int4) returns anyrecord;
>
>select a(b(2));
>


for my task I need little different form :-(

create function a(..) returns setof tables

but SQL2003 needs type table, and this can be solution

__________________________________________________ _______________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote