PostgreSQL syntax error at end of input not sure why

Question

    CREATE OR REPLACE FUNCTION customerGetByLargestSpend()
RETURNS TABLE(
    customerID INTEGER,
        firstName VARCHAR(20),
        Surname VARCHAR(40),
        totalBookings BIGINT,
        totalSpend Numeric
)

ERROR:  syntax error at end of input
LINE 8: )
         ^
SQL state: 42601
Character: 213

Not sure why this is happening.Any help would be very appreciated. thanks

You need a body for the function . . . you might start with begin/end. — Gordon Linoff
– Gordon Linoff, Commented Aug 24, 2020 at 0:54

Bohemian · Accepted Answer · 2020-08-24 01:20:14Z

1

The function is defined to return a row set, but does not return anything.

The parser expects to find something that returns rows, eg a select statement.

For example:

CREATE OR REPLACE FUNCTION customerGetByLargestSpend()
RETURNS TABLE(
customerID INTEGER,
    firstName VARCHAR(20),
    Surname VARCHAR(40),
    totalBookings BIGINT,
    totalSpend Numeric
)
AS $$ SELECT .... $$
LANGUAGE SQL

edited Aug 24, 2020 at 1:20

answered Aug 23, 2020 at 23:41

Bohemian♦

427k103 gold badges604 silver badges750 bronze badges

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

1 Comment

Hash103 Over a year ago

Doesn't seem to matter what table i put there it still doesn't return anything

Collectives™ on Stack Overflow

PostgreSQL syntax error at end of input not sure why

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related