Re: custom average window function failure

From: Sebastian P(dot) Luque <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: custom average window function failure
Date: 2016-10-09 15:01:04
Message-ID: 87pon9va6n.fsf@otaria.sebmel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 9 Oct 2016 06:44:10 -0700,
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

[...]

> Not sure. When I tried using the above(on 9.5) it failed during the
> CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with:

> ERROR: type "vector" does not exist

> So where is that coming from in your setup?

Aw nuts, I forgot to include that type definition. Here it is:

CREATE TYPE public.vector AS
(angle double precision,
magnitude double precision);
COMMENT ON TYPE public.vector
IS 'This type holds the basic descriptors of a vector; namely, angle and magnitude.';

--
Seb

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-10-09 15:37:22 Re: custom average window function failure
Previous Message Adrian Klaver 2016-10-09 13:44:10 Re: custom average window function failure