Re: Help with CREATE FUNCTION

Поиск
Список
Период
Сортировка
От Sándor Daku
Тема Re: Help with CREATE FUNCTION
Дата
Msg-id CAKyoTgYTGYRcwD5z25n4drcNrdCCH5O87pEP7RphRNGQkONyCg@mail.gmail.com
обсуждение исходный текст
Ответ на Help with CREATE FUNCTION  (Kip Warner <kip@thevertigo.com>)
Ответы Re: Help with CREATE FUNCTION  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-novice
Дерево обсуждения

On 18 April 2016 at 08:22, Kip Warner <kip@thevertigo.com> wrote:
Hey list,

I am having difficulty using CREATE FUNCTION with a subordinate SELECT
query that should operate on exactly two rows.

    http://pastebin.com/7b3Vxbuh

Any help is appreciated.

--
Kip Warner -- Senior Software Engineer
OpenPGP encrypted/signed mail preferred
http://www.thevertigo.com



Your select should look like this:

select your_const*abs(ta.col1-tb.col1)+... 
from my_table as ta, my_table as tb where ta.id = arg_id_a and tb.id = arg_id_b;

This kind of unqualified join is usually stupid, but in this time exactly what you need.    


Regards,
Sándor

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

Предыдущее
От: Kip Warner
Дата:
Сообщение: Help with CREATE FUNCTION
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Help with CREATE FUNCTION