Wrong subquery returns as 400 Bad Request

[steve-chavez]

Problem

Having a wrong view/function like:

create view bad_subquery as
select * from projects where id = (select id from projects);

postgres=# \set VERBOSITY verbose 
postgres=# select * from bad_subquery ;
ERROR:  21000: more than one row returned by a subquery used as an expression
LOCATION:  ExecSetParamPlan, nodeSubplan.c:1172

Returns a 400 Bad Request when invoked through postgREST:

$ curl localhost:3000/bad_subquery -i
HTTP/1.1 400 Bad Request

Solution

It should return 500 Internal Server Error.