{"Entry":{"collection":"func","key":"num-nonnulls","name":"num_nonnulls","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"3c9afc47a8dbc1a1207d0e0925ce29e76f4bfd3bc946b59ea5f6a98ebf58e881","derived_content_hash":"bc5b7d40b299306cbc50fdc37940480cbaf96c0b24a2cc3c6dea807637a68d3a","first_version":"9.6","group":"comparison","group_label":"Comparison Functions And Operators","groups":["comparison"],"imported_at":"2026-09-14T21:49:48.608686+08:00","last_version":"20","name":"num_nonnulls","name_key":"num_nonnulls","position":1001,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"4fb119808c7fff987edea3cc0e7edc7d13e571f78048c85eecb226dfae0ea460","repair":"wiki-repair-20261023"},"signature":"num_nonnulls ( VARIADIC \"any\" ) → integer","signature_count":1,"slug":"num-nonnulls","source_rev":"wiki-repair-20261023:f705eedeafe96dd98e569f0aba866dc8798c889b7a4b3992ec1f22ee10a0a305","summary":"Returns the number of non-null arguments.","summary_zh":""}},"Definition":{"Collection":"func","Key":"num-nonnulls","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"num-nonnulls","SourceRevision":"wiki-repair-20261023:f705eedeafe96dd98e569f0aba866dc8798c889b7a4b3992ec1f22ee10a0a305","Facts":{"description":"Returns the number of non-null arguments.","description_html":"Returns the number of non-null arguments.","description_zh":"返回非 null 参数的数量。","description_zh_html":"返回非 null 参数的数量。","doc":{"anchor":"FUNCTIONS-COMPARISON-FUNC-TABLE","file":"functions-comparison.html","slug":"18"},"group":"comparison","group_label":"Comparison Functions And Operators","lang":"en","layout":"table-new","pages":["functions-comparison.html"],"prose_only":false,"signatures":[{"description":"Returns the number of non-null arguments.","description_html":"Returns the number of non-null arguments.","description_zh":"返回非 null 参数的数量。","description_zh_html":"返回非 null 参数的数量。","examples":[{"expr":"num_nonnulls(1, NULL, 2)","result":"2"}],"html":"\u003ccode class=\"function\"\u003enum_nonnulls\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eVARIADIC\u003c/code\u003e \u003ccode class=\"type\"\u003e\"any\"\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger\u003c/code\u003e","returns":"integer","text":"num_nonnulls ( VARIADIC \"any\" ) → integer","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-comparison.html","sha256":"7f0a5c03e7b0ebe8bc33dab894da1766cb897441b436152d0a408198e717a6b2"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-COMPARISON-FUNC-TABLE","file":"functions-comparison.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"num-nonnulls","SourceDatabase":"center","Version":"18","Locale":"en","Title":"num_nonnulls","Summary":"Returns the number of non-null arguments.","BodyHTML":"Returns the number of non-null arguments.","SourceRevision":"wiki-repair-20261023:f705eedeafe96dd98e569f0aba866dc8798c889b7a4b3992ec1f22ee10a0a305","ContentHash":"c7d25423e1b9c89f143ad0cd8be40f4d74b8a12af0f647b8ff077cb975015506","Payload":{"description":"Returns the number of non-null arguments.","description_html":"Returns the number of non-null arguments.","signatures":[{"description":"Returns the number of non-null arguments.","description_html":"Returns the number of non-null arguments.","description_zh":"返回非 null 参数的数量。","description_zh_html":"返回非 null 参数的数量。","examples":[{"expr":"num_nonnulls(1, NULL, 2)","result":"2"}],"html":"\u003ccode class=\"function\"\u003enum_nonnulls\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eVARIADIC\u003c/code\u003e \u003ccode class=\"type\"\u003e\"any\"\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger\u003c/code\u003e","returns":"integer","text":"num_nonnulls ( VARIADIC \"any\" ) → integer","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"bfd378dea452c79d8612990a4ae9f4e46be8a90268dc2fb2d5c7eb2525236e98","Text":"num_nonnulls ( VARIADIC \"any\" ) → integer","Returns":"integer","Payload":{"description":"Returns the number of non-null arguments.","description_html":"Returns the number of non-null arguments.","description_zh":"返回非 null 参数的数量。","description_zh_html":"返回非 null 参数的数量。","examples":[{"expr":"num_nonnulls(1, NULL, 2)","result":"2"}],"html":"\u003ccode class=\"function\"\u003enum_nonnulls\u003c/code\u003e ( \u003ccode class=\"literal\"\u003eVARIADIC\u003c/code\u003e \u003ccode class=\"type\"\u003e\"any\"\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger\u003c/code\u003e","returns":"integer","text":"num_nonnulls ( VARIADIC \"any\" ) → integer","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}