Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with CREATE FUNCTION - Mailing list pgsql-novice

From Sándor Daku
Subject Re: Help with CREATE FUNCTION
Date
Msg-id CAKyoTgYTGYRcwD5z25n4drcNrdCCH5O87pEP7RphRNGQkONyCg@mail.gmail.com
Whole thread Raw
In response to Help with CREATE FUNCTION  (Kip Warner <kip@thevertigo.com>)
Responses Re: Help with CREATE FUNCTION
List pgsql-novice
Tree view

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 by date:

Previous
From: Kip Warner
Date:
Subject: Help with CREATE FUNCTION
Next
From: "David G. Johnston"
Date:
Subject: Re: Help with CREATE FUNCTION