Re: Can this be done with sql?

Hi,

You cannot easily return datasets from stored procedures.
there has been lots of discussion on it.

regds
mallah.



> yes, thank you, that may help but unfortunately there are are few more
> problems to face.
>
> 1. I will need to select groups from anywhere in the table so i cannot
> assume that 1 will be the start number. They will be contigous however so i
> can use another query top get the start number but is it possible to do it
> with just one select?
>
> 2. I need to display not just aggregates but the first and last value in
> the group for two of the fields. I mean by this that i need
> opening_value(field1) and closing_value(field2).
>
> 3. If this needs to be done via stored procedure how do i get it to return
> a result set. I've tried setof record but it doesn't work.
>
> thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.