Want FUNCTION to return argv[0] thru argv[6]

Поиск
Список
Период
Сортировка
От Jerry Richards
Тема Want FUNCTION to return argv[0] thru argv[6]
Дата
Msg-id 36ABCB24F11049FD933DBD21F1732067@greyhawk.tonecommander.com
обсуждение исходный текст
Ответы Re: Want FUNCTION to return argv[0] thru argv[6]  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Hello,

I am using postgres-odbc and I created the following function which is
called from a C-application.  This function returns a single argv[0] of the
form "(a,b,c,d,e,f,g)".

CREATE OR REPLACE FUNCTION PresRoute(int, int) RETURNS
TABLE(d1 text, d2 text, d3 text, d4 text, r1 bigint, r2 bigint, r3 bigint)
AS $$
SELECT PresDest1(PresNode($1,$2)), PresDest2(PresNode($1,$2)),
PresDest3(PresNode($1,$2)),
PresDest4(PresNode($1,$2)), PresRing1(PresNode($1,$2)),
PresRing2(PresNode($1,$2)),
PresRing3(PresNode($1,$2)) $$ LANGUAGE SQL;

But I would like it to return data as argv[0] thru argv[6] as shown:

d1 | d2 | d3| d4 | r1 | r2 | r3
-------------------------------
a    b    c   d    e    f    g

How should I change my function definition to achieve this?

Thanks,
Jerry


В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Comparison of Oracle and PostgreSQL full text search
Следующее
От: Ranjeeth Nagarajan
Дата:
Сообщение: order in which rules are executed