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)
Список
Дерево обсуждения
Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION Sándor Daku <daku.sandor@gmail.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION Tom Lane <tgl@sss.pgh.pa.us>
Re: Help with CREATE FUNCTION Kip Warner <kip@thevertigo.com>
Re: Help with CREATE FUNCTION "David G. Johnston" <david.g.johnston@gmail.com>
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)+...
This kind of unqualified join is usually stupid, but in this time exactly what you need.
Regards,
Sándor
В списке pgsql-novice по дате отправления
