Package: dd 0.0.0.9000

Kirill Müller

dd: Functions Provided by DuckDB

Lists DuckDB functions for integration in R's help system.

Authors:Kirill Müller [aut, cre], cynkra GmbH [fnd, cph]

dd_0.0.0.9000.tar.gz
dd_0.0.0.9000.zip(r-4.7)dd_0.0.0.9000.zip(r-4.6)dd_0.0.0.9000.zip(r-4.5)
dd_0.0.0.9000.tgz(r-4.6-any)dd_0.0.0.9000.tgz(r-4.5-any)
dd_0.0.0.9000.tar.gz(r-4.7-any)dd_0.0.0.9000.tar.gz(r-4.6-any)
dd_0.0.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html
card.svg |card.png
dd/json (API)

# Install 'dd' in R:
install.packages('dd', repos = c('https://cynkra.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/cynkra/dd/issues

Pkgdown/docs site:https://cynkra.github.io

On CRAN:

Conda:

3.95 score 12 stars 9 scripts 690 exports 0 dependencies

Last updated from:4452d176f5. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK110
source / vignettesOK255
linux-release-x86_64OK102
macos-release-arm64OK74
macos-oldrel-arm64OK118
windows-develOK87
windows-releaseOK76
windows-oldrelOK90
wasm-releaseOK83

Exports:!__postfix!~~!~~*@@>***///&&&%^^@<@<<<=>>>|||~~~~~*~~~absacosacoshaddadd_parquet_keyageaggregatealiasall_profiling_outputany_valueapplyapprox_count_distinctapprox_quantileapprox_top_karbitraryarg_maxarg_max_nullarg_minarg_min_nullargmaxargminarray_aggarray_aggrarray_aggregatearray_appendarray_applyarray_catarray_concatarray_containsarray_cosine_distancearray_cosine_similarityarray_cross_productarray_distancearray_distinctarray_dot_productarray_extractarray_filterarray_grade_uparray_hasarray_has_allarray_has_anyarray_indexofarray_inner_productarray_intersectarray_lengtharray_negative_dot_productarray_negative_inner_productarray_pop_backarray_pop_frontarray_positionarray_prependarray_push_backarray_push_frontarray_reducearray_resizearray_reversearray_reverse_sortarray_selectarray_slicearray_sortarray_to_stringarray_to_string_comma_defaultarray_transformarray_uniquearray_valuearray_wherearray_ziparrow_scanarrow_scan_dumbasciiasinasinhatanatan2atanhavgbarbase64binbit_andbit_countbit_lengthbit_orbit_positionbit_xorbitstringbitstring_aggbool_andbool_orcan_cast_implicitlycardinalitycast_to_typecbrtceilceilingcenturychar_lengthcharacter_lengthcheckpointchrcol_descriptioncollationscombineconcatconcat_wsconstant_or_nullcontainscopy_databasecorrcoscoshcotcountcount_ifcount_starcountifcovar_popcovar_sampcreate_sort_keycurrent_catalogcurrent_connection_idcurrent_databasecurrent_querycurrent_query_idcurrent_rolecurrent_schemacurrent_schemascurrent_settingcurrent_transaction_idcurrent_usercurrvaldamerau_levenshteindatabase_listdatabase_sizedate_adddate_diffdate_partdate_subdate_truncdatediffdatepartdatesubdatetruncdaydaynamedayofmonthdayofweekdayofyeardddecadedecodedegreesdisable_checkpoint_on_shutdowndisable_loggingdisable_object_cachedisable_optimizerdisable_print_progress_bardisable_profiledisable_profilingdisable_progress_bardisable_verificationdisable_verify_externaldisable_verify_fetch_rowdisable_verify_parallelismdisable_verify_serializerdivideduckdb_approx_database_countduckdb_columnsduckdb_constraintsduckdb_databasesduckdb_dependenciesduckdb_extensionsduckdb_external_file_cacheduckdb_functionsduckdb_indexesduckdb_keywordsduckdb_log_contextsduckdb_logsduckdb_logs_parsedduckdb_memoryduckdb_optimizersduckdb_prepared_statementsduckdb_schemasduckdb_secret_typesduckdb_secretsduckdb_sequencesduckdb_settingsduckdb_table_sampleduckdb_tablesduckdb_temporary_filesduckdb_typesduckdb_variablesduckdb_viewseditdist3element_atenable_checkpoint_on_shutdownenable_object_cacheenable_optimizerenable_print_progress_barenable_profileenable_profilingenable_progress_barenable_verificationencodeends_withentropyenum_codeenum_firstenum_lastenum_rangeenum_range_boundaryepochepoch_msepoch_nsepoch_usequi_width_binseraerrorevenexpextension_versionsfactorialfavgfdivfilterfinalizefirstflattenfloorfmodforce_checkpointformat_bytesformat_pg_typeformat_typeformatReadableDecimalSizeformatReadableSizefrom_base64from_binaryfrom_hexfsumfunctionsgammagcdgen_random_uuidgenerate_seriesgenerate_subscriptsgeomeangeometric_meanget_bitget_block_sizeget_current_timestampgetvariableglobgrade_upgreatestgreatest_common_divisorgroup_concathamminghas_any_column_privilegehas_column_privilegehas_database_privilegehas_foreign_data_wrapper_privilegehas_function_privilegehas_language_privilegehas_schema_privilegehas_sequence_privilegehas_server_privilegehas_table_privilegehas_tablespace_privilegehashhexhistogramhistogram_exacthistogram_valueshourilike_escapeimport_databasein_search_pathinet_client_addrinet_client_portinet_server_addrinet_server_portinstris_histogram_other_binisfiniteisinfisnanisodowisoyearjaccardjaro_similarityjaro_winkler_similarityjuliankahan_sumkurtosiskurtosis_poplastlast_daylcaselcmleastleast_common_multipleleftleft_graphemelenlength_graphemelevenshteinlgammalike_escapelistlist_aggrlist_aggregatelist_any_valuelist_appendlist_applylist_approx_count_distinctlist_avglist_bit_andlist_bit_orlist_bit_xorlist_bool_andlist_bool_orlist_catlist_concatlist_containslist_cosine_distancelist_cosine_similaritylist_countlist_distancelist_distinctlist_dot_productlist_elementlist_entropylist_extractlist_filterlist_firstlist_grade_uplist_haslist_has_alllist_has_anylist_histogramlist_indexoflist_inner_productlist_intersectlist_kurtosislist_kurtosis_poplist_lastlist_madlist_maxlist_medianlist_minlist_modelist_negative_dot_productlist_negative_inner_productlist_packlist_positionlist_prependlist_productlist_reducelist_resizelist_reverselist_reverse_sortlist_selectlist_semlist_skewnesslist_slicelist_sortlist_stddev_poplist_stddev_samplist_string_agglist_sumlist_transformlist_uniquelist_valuelist_var_poplist_var_samplist_wherelist_ziplistagglnloglog10log2lowerlpadltrimmadmake_datemake_timemake_timestampmake_timestamp_msmake_timestamp_nsmapmap_concatmap_containsmap_contains_entrymap_contains_valuemap_entriesmap_extractmap_extract_valuemap_from_entriesmap_keysmap_to_pg_oidmap_valuesmaxmax_bymd5md5_numbermd5_number_lowermd5_number_uppermeanmedianmetadata_infomicrosecondmillenniummillisecondminmin_byminutemismatchesmodmodemonthmonthnamemultiplynanosecondnextafternextvalnfc_normalizenormalized_intervalnot_ilike_escapenot_like_escapenownullifobj_descriptionoctet_lengthordparquet_bloom_probeparquet_file_metadataparquet_kv_metadataparquet_metadataparquet_scanparquet_schemaparse_dirnameparse_dirpathparse_duckdb_log_messageparse_filenameparse_pathpg_collation_is_visiblepg_conf_load_timepg_conversion_is_visiblepg_function_is_visiblepg_get_constraintdefpg_get_exprpg_get_viewdefpg_has_rolepg_is_other_temp_schemapg_my_temp_schemapg_opclass_is_visiblepg_operator_is_visiblepg_opfamily_is_visiblepg_postmaster_start_timepg_size_prettypg_table_is_visiblepg_ts_config_is_visiblepg_ts_dict_is_visiblepg_ts_parser_is_visiblepg_ts_template_is_visiblepg_type_is_visiblepg_typeofpiplatformpositionpowpowerpragma_collationspragma_database_sizepragma_metadata_infopragma_platformpragma_showpragma_storage_infopragma_table_infopragma_user_agentpragma_versionprefixprintfproductquantilequantile_contquantile_discquarterqueryquery_tabler_dataframe_scanradiansrandomrangeread_blobread_csvread_csv_autoread_parquetread_textreduceregexp_escaperegexp_extractregexp_extract_allregexp_full_matchregexp_matchesregexp_replaceregexp_split_to_arrayregexp_split_to_tableregr_avgxregr_avgyregr_countregr_interceptregr_r2regr_sloperegr_sxxregr_sxyregr_syyrepeatrepeat_rowreplacereplace_typereservoir_quantilereverserightright_graphemeroundround_evenroundbankersrowrpadrtrimsecondsemseq_scansession_userset_bitsetseedsha1sha256shobj_descriptionshowshow_databasesshow_tablesshow_tables_expandedsignsignbitsinsinhskewnesssplitsplit_partsqrtstarts_withstatsstddevstddev_popstddev_sampstorage_infostr_splitstr_split_regexstrftimestring_aggstring_splitstring_split_regexstring_to_arraystrip_accentsstrlenstrposstrptimestruct_concatstruct_containsstruct_extractstruct_hasstruct_indexofstruct_insertstruct_packstruct_positionstruct_updatesubstrsubstringsubstring_graphemesubtractsuffixsumsum_no_overflowsumkahansummarytable_infotantanhtest_all_typestest_vector_typestime_buckettimetz_byte_comparabletimezonetimezone_hourtimezone_minuteto_baseto_base64to_binaryto_centuriesto_daysto_decadesto_hexto_hoursto_microsecondsto_millenniato_millisecondsto_minutesto_monthsto_quartersto_secondsto_timestampto_weeksto_yearstransaction_timestamptranslatetrimtrunctruncate_duckdb_logstry_strptimetxid_currenttypeofucaseunbinunhexunicodeunion_extractunion_tagunion_valueunnestunpivot_listupperurl_decodeurl_encodeuseruser_agentuuiduuid_extract_timestampuuid_extract_versionuuidv4uuidv7var_popvar_sampvariancevariant_extractvariant_typeofvector_typeverify_externalverify_fetch_rowverify_parallelismverify_serializerversionwavgweekweekdayweekofyearweighted_avgwhich_secretwrite_logxoryearyearweek

Dependencies:

Readme and manuals

Help Manual

Help pageTopics
DuckDB function **
DuckDB function ****
DuckDB function //
DuckDB function ////
DuckDB function &&
DuckDB function &&&&
DuckDB function %%
DuckDB function ^pow ^
DuckDB function ^@^-at ^@
DuckDB function <@<-at <@
DuckDB function <<<<
DuckDB function <=><=>
DuckDB function >>>>
DuckDB function ~~
DuckDB function ~~~~
DuckDB function ~~*~~*
DuckDB function ~~~~~~
DuckDB function absabs
DuckDB function acosacos
DuckDB function acoshacosh
DuckDB function addadd
DuckDB function add_parquet_keyadd_parquet_key
DuckDB function ageage
DuckDB function aggregateaggregate
DuckDB function aliasalias
DuckDB function all_profiling_outputall_profiling_output
DuckDB function any_valueany_value
DuckDB function applyapply
DuckDB function approx_count_distinctapprox_count_distinct
DuckDB function approx_quantileapprox_quantile
DuckDB function approx_top_kapprox_top_k
DuckDB function arbitraryarbitrary
DuckDB function arg_maxarg_max
DuckDB function arg_max_nullarg_max_null
DuckDB function arg_minarg_min
DuckDB function arg_min_nullarg_min_null
DuckDB function argmaxargmax
DuckDB function argminargmin
DuckDB function array_aggarray_agg
DuckDB function array_aggrarray_aggr
DuckDB function array_aggregatearray_aggregate
DuckDB function array_appendarray_append
DuckDB function array_applyarray_apply
DuckDB function array_catarray_cat
DuckDB function array_concatarray_concat
DuckDB function array_containsarray_contains
DuckDB function array_cosine_distancearray_cosine_distance
DuckDB function array_cosine_similarityarray_cosine_similarity
DuckDB function array_cross_productarray_cross_product
DuckDB function array_distancearray_distance
DuckDB function array_distinctarray_distinct
DuckDB function array_dot_productarray_dot_product
DuckDB function array_extractarray_extract
DuckDB function array_filterarray_filter
DuckDB function array_grade_uparray_grade_up
DuckDB function array_hasarray_has
DuckDB function array_has_allarray_has_all
DuckDB function array_has_anyarray_has_any
DuckDB function array_indexofarray_indexof
DuckDB function array_inner_productarray_inner_product
DuckDB function array_intersectarray_intersect
DuckDB function array_lengtharray_length
DuckDB function array_negative_dot_productarray_negative_dot_product
DuckDB function array_negative_inner_productarray_negative_inner_product
DuckDB function array_pop_backarray_pop_back
DuckDB function array_pop_frontarray_pop_front
DuckDB function array_positionarray_position
DuckDB function array_prependarray_prepend
DuckDB function array_push_backarray_push_back
DuckDB function array_push_frontarray_push_front
DuckDB function array_reducearray_reduce
DuckDB function array_resizearray_resize
DuckDB function array_reversearray_reverse
DuckDB function array_reverse_sortarray_reverse_sort
DuckDB function array_selectarray_select
DuckDB function array_slicearray_slice
DuckDB function array_sortarray_sort
DuckDB function array_to_stringarray_to_string
DuckDB function array_to_string_comma_defaultarray_to_string_comma_default
DuckDB function array_transformarray_transform
DuckDB function array_uniquearray_unique
DuckDB function array_valuearray_value
DuckDB function array_wherearray_where
DuckDB function array_ziparray_zip
DuckDB function arrow_scanarrow_scan
DuckDB function arrow_scan_dumbarrow_scan_dumb
DuckDB function asciiascii
DuckDB function asinasin
DuckDB function asinhasinh
DuckDB function @@ at-
DuckDB function @>@> at->
DuckDB function atanatan
DuckDB function atan2atan2
DuckDB function atanhatanh
DuckDB function avgavg
DuckDB function barbar
DuckDB function base64base64
DuckDB function binbin
DuckDB function bit_andbit_and
DuckDB function bit_countbit_count
DuckDB function bit_lengthbit_length
DuckDB function bit_orbit_or
DuckDB function bit_positionbit_position
DuckDB function bit_xorbit_xor
DuckDB function bitstringbitstring
DuckDB function bitstring_aggbitstring_agg
DuckDB function bool_andbool_and
DuckDB function bool_orbool_or
DuckDB function can_cast_implicitlycan_cast_implicitly
DuckDB function cardinalitycardinality
DuckDB function cast_to_typecast_to_type
DuckDB function cbrtcbrt
DuckDB function ceilceil
DuckDB function ceilingceiling
DuckDB function centurycentury
DuckDB function char_lengthchar_length
DuckDB function character_lengthcharacter_length
DuckDB function checkpointcheckpoint
DuckDB function chrchr
DuckDB function col_descriptioncol_description
DuckDB function collationscollations
DuckDB function combinecombine
DuckDB function concatconcat
DuckDB function concat_wsconcat_ws
DuckDB function constant_or_nullconstant_or_null
DuckDB function containscontains
DuckDB function copy_databasecopy_database
DuckDB function corrcorr
DuckDB function coscos
DuckDB function coshcosh
DuckDB function cotcot
DuckDB function countcount
DuckDB function count_ifcount_if
DuckDB function count_starcount_star
DuckDB function countifcountif
DuckDB function covar_popcovar_pop
DuckDB function covar_sampcovar_samp
DuckDB function create_sort_keycreate_sort_key
DuckDB function current_catalogcurrent_catalog
DuckDB function current_connection_idcurrent_connection_id
DuckDB function current_databasecurrent_database
DuckDB function current_querycurrent_query
DuckDB function current_query_idcurrent_query_id
DuckDB function current_rolecurrent_role
DuckDB function current_schemacurrent_schema
DuckDB function current_schemascurrent_schemas
DuckDB function current_settingcurrent_setting
DuckDB function current_transaction_idcurrent_transaction_id
DuckDB function current_usercurrent_user
DuckDB function currvalcurrval
DuckDB function damerau_levenshteindamerau_levenshtein
DuckDB function database_listdatabase_list
DuckDB function database_sizedatabase_size
DuckDB function date_adddate_add
DuckDB function date_diffdate_diff
DuckDB function date_partdate_part
DuckDB function date_subdate_sub
DuckDB function date_truncdate_trunc
DuckDB function datediffdatediff
DuckDB function datepartdatepart
DuckDB function datesubdatesub
DuckDB function datetruncdatetrunc
DuckDB function dayday
DuckDB function daynamedayname
DuckDB function dayofmonthdayofmonth
DuckDB function dayofweekdayofweek
DuckDB function dayofyeardayofyear
DuckDB functionsdd
DuckDB function decadedecade
DuckDB function decodedecode
DuckDB function degreesdegrees
DuckDB function disable_checkpoint_on_shutdowndisable_checkpoint_on_shutdown
DuckDB function disable_loggingdisable_logging
DuckDB function disable_object_cachedisable_object_cache
DuckDB function disable_optimizerdisable_optimizer
DuckDB function disable_print_progress_bardisable_print_progress_bar
DuckDB function disable_profiledisable_profile
DuckDB function disable_profilingdisable_profiling
DuckDB function disable_progress_bardisable_progress_bar
DuckDB function disable_verificationdisable_verification
DuckDB function disable_verify_externaldisable_verify_external
DuckDB function disable_verify_fetch_rowdisable_verify_fetch_row
DuckDB function disable_verify_parallelismdisable_verify_parallelism
DuckDB function disable_verify_serializerdisable_verify_serializer
DuckDB function dividedivide
DuckDB function duckdb_approx_database_countduckdb_approx_database_count
DuckDB function duckdb_columnsduckdb_columns
DuckDB function duckdb_constraintsduckdb_constraints
DuckDB function duckdb_databasesduckdb_databases
DuckDB function duckdb_dependenciesduckdb_dependencies
DuckDB function duckdb_extensionsduckdb_extensions
DuckDB function duckdb_external_file_cacheduckdb_external_file_cache
DuckDB function duckdb_functionsduckdb_functions
DuckDB function duckdb_indexesduckdb_indexes
DuckDB function duckdb_keywordsduckdb_keywords
DuckDB function duckdb_log_contextsduckdb_log_contexts
DuckDB function duckdb_logsduckdb_logs
DuckDB function duckdb_logs_parsedduckdb_logs_parsed
DuckDB function duckdb_memoryduckdb_memory
DuckDB function duckdb_optimizersduckdb_optimizers
DuckDB function duckdb_prepared_statementsduckdb_prepared_statements
DuckDB function duckdb_schemasduckdb_schemas
DuckDB function duckdb_secret_typesduckdb_secret_types
DuckDB function duckdb_secretsduckdb_secrets
DuckDB function duckdb_sequencesduckdb_sequences
DuckDB function duckdb_settingsduckdb_settings
DuckDB function duckdb_table_sampleduckdb_table_sample
DuckDB function duckdb_tablesduckdb_tables
DuckDB function duckdb_temporary_filesduckdb_temporary_files
DuckDB function duckdb_typesduckdb_types
DuckDB function duckdb_variablesduckdb_variables
DuckDB function duckdb_viewsduckdb_views
DuckDB function editdist3editdist3
DuckDB function element_atelement_at
DuckDB function enable_checkpoint_on_shutdownenable_checkpoint_on_shutdown
DuckDB function enable_object_cacheenable_object_cache
DuckDB function enable_optimizerenable_optimizer
DuckDB function enable_print_progress_barenable_print_progress_bar
DuckDB function enable_profileenable_profile
DuckDB function enable_profilingenable_profiling
DuckDB function enable_progress_barenable_progress_bar
DuckDB function enable_verificationenable_verification
DuckDB function encodeencode
DuckDB function ends_withends_with
DuckDB function entropyentropy
DuckDB function enum_codeenum_code
DuckDB function enum_firstenum_first
DuckDB function enum_lastenum_last
DuckDB function enum_rangeenum_range
DuckDB function enum_range_boundaryenum_range_boundary
DuckDB function epochepoch
DuckDB function epoch_msepoch_ms
DuckDB function epoch_nsepoch_ns
DuckDB function epoch_usepoch_us
DuckDB function equi_width_binsequi_width_bins
DuckDB function eraera
DuckDB function errorerror
DuckDB function eveneven
DuckDB function expexp
DuckDB function extension_versionsextension_versions
DuckDB function factorialfactorial
DuckDB function favgfavg
DuckDB function fdivfdiv
DuckDB function filterfilter
DuckDB function finalizefinalize
DuckDB function firstfirst
DuckDB function flattenflatten
DuckDB function floorfloor
DuckDB function fmodfmod
DuckDB function force_checkpointforce_checkpoint
DuckDB function format_bytesformat_bytes
DuckDB function format_pg_typeformat_pg_type
DuckDB function format_typeformat_type
DuckDB function formatReadableDecimalSizeformatReadableDecimalSize
DuckDB function formatReadableSizeformatReadableSize
DuckDB function from_base64from_base64
DuckDB function from_binaryfrom_binary
DuckDB function from_hexfrom_hex
DuckDB function fsumfsum
DuckDB function functionsfunctions
DuckDB function gammagamma
DuckDB function gcdgcd
DuckDB function gen_random_uuidgen_random_uuid
DuckDB function generate_seriesgenerate_series
DuckDB function generate_subscriptsgenerate_subscripts
DuckDB function geomeangeomean
DuckDB function geometric_meangeometric_mean
DuckDB function get_bitget_bit
DuckDB function get_block_sizeget_block_size
DuckDB function get_current_timestampget_current_timestamp
DuckDB function getvariablegetvariable
DuckDB function globglob
DuckDB function grade_upgrade_up
DuckDB function greatestgreatest
DuckDB function greatest_common_divisorgreatest_common_divisor
DuckDB function group_concatgroup_concat
DuckDB function hamminghamming
DuckDB function has_any_column_privilegehas_any_column_privilege
DuckDB function has_column_privilegehas_column_privilege
DuckDB function has_database_privilegehas_database_privilege
DuckDB function has_foreign_data_wrapper_privilegehas_foreign_data_wrapper_privilege
DuckDB function has_function_privilegehas_function_privilege
DuckDB function has_language_privilegehas_language_privilege
DuckDB function has_schema_privilegehas_schema_privilege
DuckDB function has_sequence_privilegehas_sequence_privilege
DuckDB function has_server_privilegehas_server_privilege
DuckDB function has_table_privilegehas_table_privilege
DuckDB function has_tablespace_privilegehas_tablespace_privilege
DuckDB function hashhash
DuckDB function hexhex
DuckDB function histogramhistogram
DuckDB function histogram_exacthistogram_exact
DuckDB function histogram_valueshistogram_values
DuckDB function hourhour
DuckDB function ilike_escapeilike_escape
DuckDB function import_databaseimport_database
DuckDB function in_search_pathin_search_path
DuckDB function inet_client_addrinet_client_addr
DuckDB function inet_client_portinet_client_port
DuckDB function inet_server_addrinet_server_addr
DuckDB function inet_server_portinet_server_port
DuckDB function instrinstr
DuckDB function is_histogram_other_binis_histogram_other_bin
DuckDB function isfiniteisfinite
DuckDB function isinfisinf
DuckDB function isnanisnan
DuckDB function isodowisodow
DuckDB function isoyearisoyear
DuckDB function jaccardjaccard
DuckDB function jaro_similarityjaro_similarity
DuckDB function jaro_winkler_similarityjaro_winkler_similarity
DuckDB function julianjulian
DuckDB function kahan_sumkahan_sum
DuckDB function kurtosiskurtosis
DuckDB function kurtosis_popkurtosis_pop
DuckDB function lastlast
DuckDB function last_daylast_day
DuckDB function lcaselcase
DuckDB function lcmlcm
DuckDB function leastleast
DuckDB function least_common_multipleleast_common_multiple
DuckDB function leftleft
DuckDB function left_graphemeleft_grapheme
DuckDB function lenlen
DuckDB function length_graphemelength_grapheme
DuckDB function levenshteinlevenshtein
DuckDB function lgammalgamma
DuckDB function like_escapelike_escape
DuckDB function listlist
DuckDB function list_aggrlist_aggr
DuckDB function list_aggregatelist_aggregate
DuckDB function list_any_valuelist_any_value
DuckDB function list_appendlist_append
DuckDB function list_applylist_apply
DuckDB function list_approx_count_distinctlist_approx_count_distinct
DuckDB function list_avglist_avg
DuckDB function list_bit_andlist_bit_and
DuckDB function list_bit_orlist_bit_or
DuckDB function list_bit_xorlist_bit_xor
DuckDB function list_bool_andlist_bool_and
DuckDB function list_bool_orlist_bool_or
DuckDB function list_catlist_cat
DuckDB function list_concatlist_concat
DuckDB function list_containslist_contains
DuckDB function list_cosine_distancelist_cosine_distance
DuckDB function list_cosine_similaritylist_cosine_similarity
DuckDB function list_countlist_count
DuckDB function list_distancelist_distance
DuckDB function list_distinctlist_distinct
DuckDB function list_dot_productlist_dot_product
DuckDB function list_elementlist_element
DuckDB function list_entropylist_entropy
DuckDB function list_extractlist_extract
DuckDB function list_filterlist_filter
DuckDB function list_firstlist_first
DuckDB function list_grade_uplist_grade_up
DuckDB function list_haslist_has
DuckDB function list_has_alllist_has_all
DuckDB function list_has_anylist_has_any
DuckDB function list_histogramlist_histogram
DuckDB function list_indexoflist_indexof
DuckDB function list_inner_productlist_inner_product
DuckDB function list_intersectlist_intersect
DuckDB function list_kurtosislist_kurtosis
DuckDB function list_kurtosis_poplist_kurtosis_pop
DuckDB function list_lastlist_last
DuckDB function list_madlist_mad
DuckDB function list_maxlist_max
DuckDB function list_medianlist_median
DuckDB function list_minlist_min
DuckDB function list_modelist_mode
DuckDB function list_negative_dot_productlist_negative_dot_product
DuckDB function list_negative_inner_productlist_negative_inner_product
DuckDB function list_packlist_pack
DuckDB function list_positionlist_position
DuckDB function list_prependlist_prepend
DuckDB function list_productlist_product
DuckDB function list_reducelist_reduce
DuckDB function list_resizelist_resize
DuckDB function list_reverselist_reverse
DuckDB function list_reverse_sortlist_reverse_sort
DuckDB function list_selectlist_select
DuckDB function list_semlist_sem
DuckDB function list_skewnesslist_skewness
DuckDB function list_slicelist_slice
DuckDB function list_sortlist_sort
DuckDB function list_stddev_poplist_stddev_pop
DuckDB function list_stddev_samplist_stddev_samp
DuckDB function list_string_agglist_string_agg
DuckDB function list_sumlist_sum
DuckDB function list_transformlist_transform
DuckDB function list_uniquelist_unique
DuckDB function list_valuelist_value
DuckDB function list_var_poplist_var_pop
DuckDB function list_var_samplist_var_samp
DuckDB function list_wherelist_where
DuckDB function list_ziplist_zip
DuckDB function listagglistagg
DuckDB function lnln
DuckDB function loglog
DuckDB function log10log10
DuckDB function log2log2
DuckDB function lowerlower
DuckDB function lpadlpad
DuckDB function ltrimltrim
DuckDB function madmad
DuckDB function make_datemake_date
DuckDB function make_timemake_time
DuckDB function make_timestampmake_timestamp
DuckDB function make_timestamp_msmake_timestamp_ms
DuckDB function make_timestamp_nsmake_timestamp_ns
DuckDB function mapmap
DuckDB function map_concatmap_concat
DuckDB function map_containsmap_contains
DuckDB function map_contains_entrymap_contains_entry
DuckDB function map_contains_valuemap_contains_value
DuckDB function map_entriesmap_entries
DuckDB function map_extractmap_extract
DuckDB function map_extract_valuemap_extract_value
DuckDB function map_from_entriesmap_from_entries
DuckDB function map_keysmap_keys
DuckDB function map_to_pg_oidmap_to_pg_oid
DuckDB function map_valuesmap_values
DuckDB function maxmax
DuckDB function max_bymax_by
DuckDB function md5md5
DuckDB function md5_numbermd5_number
DuckDB function md5_number_lowermd5_number_lower
DuckDB function md5_number_uppermd5_number_upper
DuckDB function meanmean
DuckDB function medianmedian
DuckDB function metadata_infometadata_info
DuckDB function microsecondmicrosecond
DuckDB function millenniummillennium
DuckDB function millisecondmillisecond
DuckDB function minmin
DuckDB function min_bymin_by
DuckDB function minuteminute
DuckDB function mismatchesmismatches
DuckDB function modmod
DuckDB function modemode
DuckDB function monthmonth
DuckDB function monthnamemonthname
DuckDB function multiplymultiply
DuckDB function nanosecondnanosecond
DuckDB function nextafternextafter
DuckDB function nextvalnextval
DuckDB function nfc_normalizenfc_normalize
DuckDB function normalized_intervalnormalized_interval
DuckDB function not_ilike_escapenot_ilike_escape
DuckDB function not_like_escapenot_like_escape
DuckDB function !__postfix!__postfix not-__postfix
DuckDB function !~~!~~ not-~~
DuckDB function !~~*!~~* not-~~*
DuckDB function nownow
DuckDB function nullifnullif
DuckDB function obj_descriptionobj_description
DuckDB function octet_lengthoctet_length
DuckDB function |or- |
DuckDB function ||or--or ||
DuckDB function ordord
DuckDB function parquet_bloom_probeparquet_bloom_probe
DuckDB function parquet_file_metadataparquet_file_metadata
DuckDB function parquet_kv_metadataparquet_kv_metadata
DuckDB function parquet_metadataparquet_metadata
DuckDB function parquet_scanparquet_scan
DuckDB function parquet_schemaparquet_schema
DuckDB function parse_dirnameparse_dirname
DuckDB function parse_dirpathparse_dirpath
DuckDB function parse_duckdb_log_messageparse_duckdb_log_message
DuckDB function parse_filenameparse_filename
DuckDB function parse_pathparse_path
DuckDB function pg_collation_is_visiblepg_collation_is_visible
DuckDB function pg_conf_load_timepg_conf_load_time
DuckDB function pg_conversion_is_visiblepg_conversion_is_visible
DuckDB function pg_function_is_visiblepg_function_is_visible
DuckDB function pg_get_constraintdefpg_get_constraintdef
DuckDB function pg_get_exprpg_get_expr
DuckDB function pg_get_viewdefpg_get_viewdef
DuckDB function pg_has_rolepg_has_role
DuckDB function pg_is_other_temp_schemapg_is_other_temp_schema
DuckDB function pg_my_temp_schemapg_my_temp_schema
DuckDB function pg_opclass_is_visiblepg_opclass_is_visible
DuckDB function pg_operator_is_visiblepg_operator_is_visible
DuckDB function pg_opfamily_is_visiblepg_opfamily_is_visible
DuckDB function pg_postmaster_start_timepg_postmaster_start_time
DuckDB function pg_size_prettypg_size_pretty
DuckDB function pg_table_is_visiblepg_table_is_visible
DuckDB function pg_ts_config_is_visiblepg_ts_config_is_visible
DuckDB function pg_ts_dict_is_visiblepg_ts_dict_is_visible
DuckDB function pg_ts_parser_is_visiblepg_ts_parser_is_visible
DuckDB function pg_ts_template_is_visiblepg_ts_template_is_visible
DuckDB function pg_type_is_visiblepg_type_is_visible
DuckDB function pg_typeofpg_typeof
DuckDB function pipi
DuckDB function platformplatform
DuckDB function positionposition
DuckDB function powerpower
DuckDB function pragma_collationspragma_collations
DuckDB function pragma_database_sizepragma_database_size
DuckDB function pragma_metadata_infopragma_metadata_info
DuckDB function pragma_platformpragma_platform
DuckDB function pragma_showpragma_show
DuckDB function pragma_storage_infopragma_storage_info
DuckDB function pragma_table_infopragma_table_info
DuckDB function pragma_user_agentpragma_user_agent
DuckDB function pragma_versionpragma_version
DuckDB function prefixprefix
DuckDB function printfprintf
DuckDB function productproduct
DuckDB function quantilequantile
DuckDB function quantile_contquantile_cont
DuckDB function quantile_discquantile_disc
DuckDB function quarterquarter
DuckDB function queryquery
DuckDB function query_tablequery_table
DuckDB function r_dataframe_scanr_dataframe_scan
DuckDB function radiansradians
DuckDB function randomrandom
DuckDB function rangerange
DuckDB function read_blobread_blob
DuckDB function read_csvread_csv
DuckDB function read_csv_autoread_csv_auto
DuckDB function read_parquetread_parquet
DuckDB function read_textread_text
DuckDB function reducereduce
DuckDB function regexp_escaperegexp_escape
DuckDB function regexp_extractregexp_extract
DuckDB function regexp_extract_allregexp_extract_all
DuckDB function regexp_full_matchregexp_full_match
DuckDB function regexp_matchesregexp_matches
DuckDB function regexp_replaceregexp_replace
DuckDB function regexp_split_to_arrayregexp_split_to_array
DuckDB function regexp_split_to_tableregexp_split_to_table
DuckDB function regr_avgxregr_avgx
DuckDB function regr_avgyregr_avgy
DuckDB function regr_countregr_count
DuckDB function regr_interceptregr_intercept
DuckDB function regr_r2regr_r2
DuckDB function regr_sloperegr_slope
DuckDB function regr_sxxregr_sxx
DuckDB function regr_sxyregr_sxy
DuckDB function regr_syyregr_syy
DuckDB function repeatrepeat
DuckDB function repeat_rowrepeat_row
DuckDB function replacereplace
DuckDB function replace_typereplace_type
DuckDB function reservoir_quantilereservoir_quantile
DuckDB function reversereverse
DuckDB function rightright
DuckDB function right_graphemeright_grapheme
DuckDB function roundround
DuckDB function round_evenround_even
DuckDB function roundbankersroundbankers
DuckDB function rowrow
DuckDB function rpadrpad
DuckDB function rtrimrtrim
DuckDB function secondsecond
DuckDB function semsem
DuckDB function seq_scanseq_scan
DuckDB function session_usersession_user
DuckDB function set_bitset_bit
DuckDB function setseedsetseed
DuckDB function sha1sha1
DuckDB function sha256sha256
DuckDB function shobj_descriptionshobj_description
DuckDB function showshow
DuckDB function show_databasesshow_databases
DuckDB function show_tablesshow_tables
DuckDB function show_tables_expandedshow_tables_expanded
DuckDB function signsign
DuckDB function signbitsignbit
DuckDB function sinsin
DuckDB function sinhsinh
DuckDB function skewnessskewness
DuckDB function splitsplit
DuckDB function split_partsplit_part
DuckDB function sqrtsqrt
DuckDB function starts_withstarts_with
DuckDB function statsstats
DuckDB function stddevstddev
DuckDB function stddev_popstddev_pop
DuckDB function stddev_sampstddev_samp
DuckDB function storage_infostorage_info
DuckDB function str_splitstr_split
DuckDB function str_split_regexstr_split_regex
DuckDB function strftimestrftime
DuckDB function string_aggstring_agg
DuckDB function string_splitstring_split
DuckDB function string_split_regexstring_split_regex
DuckDB function string_to_arraystring_to_array
DuckDB function strip_accentsstrip_accents
DuckDB function strlenstrlen
DuckDB function strposstrpos
DuckDB function strptimestrptime
DuckDB function struct_concatstruct_concat
DuckDB function struct_containsstruct_contains
DuckDB function struct_extractstruct_extract
DuckDB function struct_hasstruct_has
DuckDB function struct_indexofstruct_indexof
DuckDB function struct_insertstruct_insert
DuckDB function struct_packstruct_pack
DuckDB function struct_positionstruct_position
DuckDB function struct_updatestruct_update
DuckDB function substrsubstr
DuckDB function substringsubstring
DuckDB function substring_graphemesubstring_grapheme
DuckDB function subtractsubtract
DuckDB function suffixsuffix
DuckDB function sumsum
DuckDB function sum_no_overflowsum_no_overflow
DuckDB function sumkahansumkahan
DuckDB function summarysummary
DuckDB function table_infotable_info
DuckDB function tantan
DuckDB function tanhtanh
DuckDB function test_all_typestest_all_types
DuckDB function test_vector_typestest_vector_types
DuckDB function time_buckettime_bucket
DuckDB function timetz_byte_comparabletimetz_byte_comparable
DuckDB function timezonetimezone
DuckDB function timezone_hourtimezone_hour
DuckDB function timezone_minutetimezone_minute
DuckDB function to_baseto_base
DuckDB function to_base64to_base64
DuckDB function to_binaryto_binary
DuckDB function to_centuriesto_centuries
DuckDB function to_daysto_days
DuckDB function to_decadesto_decades
DuckDB function to_hexto_hex
DuckDB function to_hoursto_hours
DuckDB function to_microsecondsto_microseconds
DuckDB function to_millenniato_millennia
DuckDB function to_millisecondsto_milliseconds
DuckDB function to_minutesto_minutes
DuckDB function to_monthsto_months
DuckDB function to_quartersto_quarters
DuckDB function to_secondsto_seconds
DuckDB function to_timestampto_timestamp
DuckDB function to_weeksto_weeks
DuckDB function to_yearsto_years
DuckDB function transaction_timestamptransaction_timestamp
DuckDB function translatetranslate
DuckDB function trimtrim
DuckDB function trunctrunc
DuckDB function truncate_duckdb_logstruncate_duckdb_logs
DuckDB function try_strptimetry_strptime
DuckDB function txid_currenttxid_current
DuckDB function typeoftypeof
DuckDB function ucaseucase
DuckDB function unbinunbin
DuckDB function unhexunhex
DuckDB function unicodeunicode
DuckDB function union_extractunion_extract
DuckDB function union_tagunion_tag
DuckDB function union_valueunion_value
DuckDB function unnestunnest
DuckDB function unpivot_listunpivot_list
DuckDB function upperupper
DuckDB function url_decodeurl_decode
DuckDB function url_encodeurl_encode
DuckDB function useruser
DuckDB function user_agentuser_agent
DuckDB function uuiduuid
DuckDB function uuid_extract_timestampuuid_extract_timestamp
DuckDB function uuid_extract_versionuuid_extract_version
DuckDB function uuidv4uuidv4
DuckDB function uuidv7uuidv7
DuckDB function var_popvar_pop
DuckDB function var_sampvar_samp
DuckDB function variancevariance
DuckDB function variant_extractvariant_extract
DuckDB function variant_typeofvariant_typeof
DuckDB function vector_typevector_type
DuckDB function verify_externalverify_external
DuckDB function verify_fetch_rowverify_fetch_row
DuckDB function verify_parallelismverify_parallelism
DuckDB function verify_serializerverify_serializer
DuckDB function versionversion
DuckDB function wavgwavg
DuckDB function weekweek
DuckDB function weekdayweekday
DuckDB function weekofyearweekofyear
DuckDB function weighted_avgweighted_avg
DuckDB function which_secretwhich_secret
DuckDB function write_logwrite_log
DuckDB function xorxor
DuckDB function yearyear
DuckDB function yearweekyearweek