PostgresQL Syntax Error at end of input, how do I troubleshoot this?

Question

I am getting an error in my PostGresQL code.

org.postgresql.util.PSQLException: ERROR: syntax error at end of input Position: 250 FROM tutorial.crunchbase_companies

This usually works so I am not sure what my error means.

Sample data and desired results would help. What does "percent total of distinct count" mean? — Gordon Linoff
– Gordon Linoff, Commented Mar 3, 2021 at 15:51
As far as I can see, the error message is raised because you are missing a closing paranthesis at the end. — S-Man
– S-Man, Commented Mar 3, 2021 at 15:56
Your last column when you try to divide by after the 100 you have an open paren ( but no closing one anywhere. — Brad
– Brad, Commented Mar 3, 2021 at 15:56

Gordon Linoff · Accepted Answer · 2021-03-03 15:54:02Z

1

I suspect that you want the total companies, the companies with non-NULL values for a column and the ratio.

If so, this has nothing to do with distinct:

SELECT COUNT(*),
       COUNT(funding_total_usd) as num_with_funding,
       AVG( (funding_total_usd IS NOT NULL)::int ) as ratio_with_funding
FROM tutorial.crunchbase_companies;

answered Mar 3, 2021 at 15:54

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

PostgresQL Syntax Error at end of input, how do I troubleshoot this?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related