Re: Create function problem
| От | gustavo halperin |
|---|---|
| Тема | Re: Create function problem |
| Дата | |
| Msg-id | 44D37744.3040301@gmail.com обсуждение исходный текст |
| Ответ на | Re: Create function problem (Michael Fuhr <mike@fuhr.org>) |
| Список | pgsql-general |
Michael Fuhr wrote:
> On Fri, Aug 04, 2006 at 06:44:16PM +0300, gustavo halperin wrote:
>
>> Michael Fuhr wrote:
>>
>>> Since the function has OUT parameters you can use "RETURNS SETOF record"
>>> like this:
>>>
>>> CREATE FUNCTION funcname(<params>) RETURNS SETOF record AS $$
>>> <body>
>>> $$ LANGUAGE SQL
>>>
>> What do you mean with the word "record", can you give an example of how
>> this "record" looks for two columns ?
>>
>
> "record" means the literal word "record". Example:
>
> CREATE FUNCTION show_tables(OUT schema_name text, OUT table_name text)
> RETURNS SETOF record AS $$
> SELECT table_schema, table_name
> FROM information_schema.tables;
> $$ LANGUAGE sql;
>
> SELECT * FROM show_tables()
Thank you, IS WORK, Thank you very much for your help.
Gustavo
В списке pgsql-general по дате отправления: