Re: [PATCHES] allow select from void function in void sql function
> Hello > > this small patch allow use sql for creating wrappers others void functions. > Currently void SQL function have to be empty. > > create or replace function foo(int) returns void as ' ','' language c ..; > create or replace function foo() returns void as $$ select foo(10); > $$language sql; > > regards > Pavel > i'm not clear on what the use case of this can be... of course, my opinion is not very important :) First. I write bigger C library - implementation of some dbms_packages and plvision packages. I don't expect using plpgsql. I have a lot of void functions. Usually set_...unset_ with and I need sql language for createing wrappers for default values. That's all. Second. The logic in PostgreSQL is wrong now. Is too hard and too simple. I can get VOID value via SELECT void function too. Pavel _ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] allow select from void function in void sql function
On Thu, Mar 16, 2006 at 10:56:43PM -0500, Jaime Casanova wrote: > On 3/16/06, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > Hello > > > > this small patch allow use sql for creating wrappers others void > > functions. Currently void SQL function have to be empty. > > > > create or replace function foo(int) returns void as ' ','' > > language c ..; create or replace function foo() returns void as $$ > > select foo(10); $$language sql; > > > > i'm not clear on what the use case of this can be... of course, my > opinion is not very important :) I can think of a case. Let's imagine you want to do (roughly) the equivalent of CALL, which we don't have yet. This would let you have what amounts to a stored procedure, i.e. something that takes an action but doesn't return rows. :) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] allow select from void function in void sql function
On 3/16/06, Pavel Stehule <[EMAIL PROTECTED]> wrote: > Hello > > this small patch allow use sql for creating wrappers others void functions. > Currently void SQL function have to be empty. > > create or replace function foo(int) returns void as ' ','' language c ..; > create or replace function foo() returns void as $$ select foo(10); > $$language sql; > > regards > Pavel > i'm not clear on what the use case of this can be... of course, my opinion is not very important :) -- regards, Jaime Casanova "What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting the wrong answer really fast." Randal L. Schwartz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match