From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Kip Warner <kip(at)thevertigo(dot)com> |
Cc: | Sándor Daku <daku(dot)sandor(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Help with CREATE FUNCTION |
Date: | 2016-04-18 17:58:54 |
Message-ID: | CAKFQuwYZGVNKq7bLEAUZfW7UiBWroypJ_oc0qdBk5m7eNRm_ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Monday, April 18, 2016, Kip Warner <kip(at)thevertigo(dot)com> wrote:
> On Mon, 2016-04-18 at 08:00 -0700, David G. Johnston wrote:
> > Arguably its still stupid :)
> >
> > SELECT [...]
> > FROM (SELECT * FROM my_table WHERE id = arg_id_a) AS ta
> > CROSS JOIN (SELECT * FROM my_table WHERE id = arg_id_b) AS tb
> >
> > David J.
>
> Thank you very much David and Sándor. If I understand correctly, the
> function should then look like so...
>
> DROP FUNCTION IF EXISTS my_function(id_a integer, id_b integer);
>
> constant1 CONSTANT float := 0.123;
> constant2 CONSTANT float := 0.456;
> constant3 CONSTANT float := 0.789;
What are these supposed to represent?
From | Date | Subject | |
---|---|---|---|
Next Message | Kip Warner | 2016-04-18 18:04:24 | Re: Help with CREATE FUNCTION |
Previous Message | David G. Johnston | 2016-04-18 17:57:26 | Re: Help with CREATE FUNCTION |