1

What is wrong with the following SQL query on my data? I found pretty clear documentation (1,2) that the function is supposed to work.

SELECT CDB_QuantileBins(array_agg(numeric_column_of_mine), 10) from my_table
  • What is the exact text of the error message? Is the extension associated with this function installed in your database? Show the output of \df *.CDB_QuantileBins in psql. Mention any relevant versions. Please edit your question, comment here when done. – Craig Ringer Apr 3 '14 at 23:24
  • @CraigRinger I am not following, sorry. Can I query this (df) in the web interface as well? How exactly, sorry. But no, I did not install any extension, I thought this must work out-of-the box on the site. – László Apr 3 '14 at 23:35
  • 1
    Ah, you're using a PostgreSQL fork or some kind of canned service/extension (cartodb). Didn't spot that right away. Never mind. You should still show the exact text of the error message though. – Craig Ringer Apr 4 '14 at 1:35
1

There seems to be a type inflexiblity in the function. Try this,

SELECT CDB_QuantileBins(array_agg(numeric_column_of_mine::numeric), 10) FROM my_table

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.