I want to add this function in sql in a Postgresql Database

Question

I have written this function:

create function check_same_price() returns integer as $result$
declare
 result integer;
begin
 set res = (select *
  from (select count(distinct title), price_dvd_buy
  from dvd_to_buy
  group by price_dvd_buy) as dummy
  where count>1);
if (res==none) then result=0;
else result=1;
end if;
end;
$result$ language plpgsql;

the function returns 0 if there is the same price for same title, otherwise it returns 1. This check is done because I want the same price for the same film; I'm using phppgadmin to manage it. I receive this error:

SQL error:

ERROR:  error of sintax to or near "("
LINE 5:  set res = (select *

What's wrong, I don't know to fix it. Thanks!

There is no set in PL/pgSQL. Please read the manual: postgresql.org/docs/current/static/… — user330315
– user330315, Commented May 27, 2015 at 16:46

Pavel Stehule · Accepted Answer · 2015-05-28 07:37:13Z

1

create function check_same_price()
returns boolean as $$
begin
   return exists(select count(distinct title)
                    from dvd_to_buy
                   group by price_dvd_buy
                   having count(distinct title) > 1)
end;
$$ language plpgsql;

answered May 28, 2015 at 7:37

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I want to add this function in sql in a Postgresql Database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related