Re: [HACKERS] can plpgsql returns more flexibe value ?

xample "The world's most advanced >PostgreSQL client interface" > >http://jdbc.postgresql.org/documentation/80/ch06.html#callproc-resultset-refcursor > >Kris Jurka > Arnold.Zhu [EMAIL PROTECTED] 2005-01

Re: [HACKERS] can plpgsql returns more flexibe value ?

gt;Kris Jurka > Can I use DataAdapter.Fill() with refcursor. :-( I don't want to fetch data one bye one. Thanks & Regards Arnold.Zhu [EMAIL PROTECTED] 2005-01-23 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] can plpgsql returns more flexibe value ?

esultset directly into Dataset, this method will should use more sql to get data, it lose function's convenience like stored procedure. Thanks & Regards! Arnold.Zhu 2005-01-22 ---(end of broadcast)--- TIP 9: the p

[HACKERS] can plpgsql returns more flexibe value ?

o create many type for function's return. Can plpgsql returns result set according to what exactly fetched, then take return type as references to store data for return. Whether there is some better way to deal with this problem? Thanks & Regards Arnold.Zhu 2005-01-21 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql,isit available?

plpgsql; ----- Thanks & Regards! Arnold.Zhu 2004-11-26 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql,isit available?

a simple test case with the expected >result so we can work on it. Thanks & Regards! Arnold.Zhu 2000-11-26 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql,is it available?

@ in program. Thanks & Regards! Arnold.Zhu 2000-11-25 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

Hello, Michael Fuhr I've changed my clock. Back to future now. ^_^ Thanks & Regards! Arnold.Zhu 2004-11-24 === 2004-11-24 13:52:05 You wrote: === >On Tue, Nov 23, 2004 at 10:46:54PM -0700, Michael Fuhr wrote: > >> On Thu, Nov 23, 200

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

only change Npgsql driver not to trim "@" and stored procedure to plpgsql. Is my description clear enough to express my thought? Waiting for your further replys. Thanks & Regards! Arnold.Zhu 2004-11-24 ---(end of broadcast

[HACKERS] How to make @id or $id as parameter name in plpgsql, is it available?

SETOF users_set AS ' declare rec record; begin for rec in select * from users where id = @id loop return next rec; end loop; return; end; 'LANGUAGE plpgsql; --- Thanks &