Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt

Use this file to discover all available pages before exploring further.

The following query counts the number of values in a field: 
SELECT pdb.agg('{"value_count": {"field": "rating"}}') FROM mock_items
WHERE id @@@ pdb.all();
Expected Response
       agg
-----------------
 {"value": 41.0}
(1 row)
See the Tantivy documentation for all available options.

​
SQL Count Syntax

SQL’s COUNT syntax is supported in beta. To enable it, first run 
SET paradedb.enable_aggregate_custom_scan TO on;
With this feature enabled, the following query is equivalent to the above and is executed in the same way. 
SELECT COUNT(rating) FROM mock_items
WHERE id @@@ pdb.all();
To count all rows, including rows with null values, use COUNT(*): 
SELECT COUNT(*) FROM mock_items
WHERE id @@@ pdb.all();