Re: Help with CREATE FUNCTION

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: Whole Thread | Raw Message | 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?

In response to

Browse pgsql-novice by date

  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