From: | stefanov(dot)sm(at)abv(dot)bg |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13751: PGAdmin III function text error |
Date: | 2015-10-30 20:14:00 |
Message-ID: | 20151030201400.3017.89775@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13751
Logged by: Stefan Stefanov
Email address: stefanov(dot)sm(at)abv(dot)bg
PostgreSQL version: 9.5beta1
Operating system: Windows 7 x64
Description:
Define this function:
CREATE OR REPLACE FUNCTION demi.order_stat() RETURNS SETOF
demi.order_status_type AS
$BODY$
SELECT mr.id AS "Партида", mr.name AS "Група клиенти",
COUNT(*) FILTER (WHERE sl.value = 0) AS "Непретеглени",
COUNT(*) AS "Всички"
FROM demi.master mr INNER JOIN demi.slave sl ON mr.id = sl.master_id
WHERE mr.ready = 0
GROUP BY mr.id, mr.name;
$BODY$
LANGUAGE sql STABLE;
When you select the function in Object browser or rightclick-Scripts-Create
scrit then the script has an extra SETOF:
-- Function: demi.order_stat()
-- DROP FUNCTION demi.order_stat();
CREATE OR REPLACE FUNCTION demi.order_stat()
RETURNS SETOF SETOF demi.order_status_type AS
$BODY$
SELECT mr.id AS "Партида", mr.name AS "Група клиенти",
COUNT(*) FILTER (WHERE sl.value = 0) AS "Непретеглени",
COUNT(*) AS "Всички"
FROM demi.master mr INNER JOIN demi.slave sl ON mr.id = sl.master_id
WHERE mr.ready = 0
GROUP BY mr.id, mr.name;
$BODY$
LANGUAGE sql STABLE
COST 100
ROWS 1000;
ALTER FUNCTION demi.order_stat()
OWNER TO postgres;
From | Date | Subject | |
---|---|---|---|
Next Message | David Gould | 2015-10-31 04:23:17 | Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower. |
Previous Message | Tom Lane | 2015-10-30 17:41:36 | Re: BUG #13667: SSI violation... |