Re: Function
От | Sumita Biswas |
---|---|
Тема | Re: Function |
Дата | |
Msg-id | 007e01c3f78d$ad346f50$2a154d0a@apac.cisco.com обсуждение исходный текст |
Ответ на | Re: Function ("scott.marlowe" <scott.marlowe@ihs.com>) |
Ответы |
Re: Function
|
Список | pgsql-sql |
I have a postgres function that returns a boolean, I want to use this return in another function. How do I do it? Will the following code help me fetch it in a variable: select lv_flag = drop_table_if_exists(''alarmconfig'',false); drop_table_if_exists is the function which I want to call. Any help is appreciated. Thanks, Sumita -----Original Message----- From: scott.marlowe [mailto:scott.marlowe@ihs.com] Sent: Wednesday, February 18, 2004 4:17 AM To: Sumita Biswas (sbiswas) Cc: 'Stephan Szabo'; pgsql-sql@postgresql.org Subject: Re: [SQL] Function On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote: > Thanks for the answer. > I have one more issue. How do I test a function that I wrote? I was > able to create a function called Proc_ConferenceSummary(). In SQL > Server I used to run it through query analyzer by writing the > following command: exec Proc_ConferenceSummary > '12/1/2003','1/23/2004',1,1,0,5001 > > But I don't know how to do it in Postgresql. select functioname(arg1,arg2,arg3);
В списке pgsql-sql по дате отправления: