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
Re: [PATCHES] farsi translation: file fa_IR.po updated.
Mahmoud Taghizadeh wrote: > please update the file. Done. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[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 _ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/ void_wrap.dif Description: Binary data ---(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
