Results of 1 - 7 of about 7 for family (0.002 sec.)
- JSON Processing Functions 13123
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...g DuckDB's JSON data type uses 0-based indexing . Examples: CREATE TABLE example (j JSON); INSERT INTO example VALUES ('{ "family": "anatidae", "species": [ "duck", "goose", "swan", null ] }'); SELECT json_extract(j, '$.family') FROM example; "anatidae..." SELECT j->'$.family' FROM example; "anatidae" SELECT j->'$.species[0]' FROM example; "duck" SELECT j->'$.species[*]' FROM example; ["duck", "g...ROM example; "duck" SELECT j->'species'->['/0', '/1'] FROM example; ['"duck"', '"goose"'] SELECT json_extract_string(j, '$.family') FROM example; anatidae SELECT j->>'$.family' FROM example; anatidae SELECT j->>'$.species[0]' FROM example; duck SELECT... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- JSON Overview 10196
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...ith a column for storing JSON data and insert data into it: CREATE TABLE example (j JSON); INSERT INTO example VALUES ('{ "family": "anatidae", "species": [ "duck", "goose", "swan", null ] }'); Retrieving JSON Data Retrieve the family key's value: SELE...CT j.family FROM example; "anatidae" Extract the family key's value with a JSONPath expression as JSON : SELECT j->'$.family' FROM exa...mple; "anatidae" Extract the family key's value with a JSONPath expression as a VARCHAR : SELECT j->>'$.family' FROM example; anatidae Using Quotes for Specia... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- Run Queries 8433
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...// A JSON object (or STRUCT) value read into a map. var obj duckdb.Composite[map[string]any] row = db.QueryRow(`SELECT '{"family": "anatidae", "coolness": 42.42}'::JSON`) if err := row.Scan(&obj); err != nil { log.Fatal(err) } log.Printf("family: %s",...obj.Get()["family"]) This follows the client's json example . To read whole result sets as columnar batches instead of row by row, see Handl... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Prepared Statements 8106
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
...ith different parameters. DuckDB supports prepared statements in the C API with the duckdb_prepare method. The duckdb_bind family of functions is used to supply values for subsequent execution of the prepared statement using duckdb_execute_prepared . A...n case the prepare fails, the error can be obtained through duckdb_prepare_error . It is not required that the duckdb_bind family of functions matches the prepared statement parameter type exactly. The values will be auto-cast to the required value as... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Swift Client 7979
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...while the query is executing. We'll then cast the result columns to Swift native types using DuckDB's ResultSet cast(to:) family of methods, before finally wrapping them up in a DataFrame from the TabularData framework. ... import TabularData extensio... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- What's New in the Docs for 2.0 7942
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...VARIANT type stores semi-structured, schema-less data such as JSON while keeping the performance of columnar execution. A family of variant_* functions constructs and inspects variant values. Variant type Variant functions Triggers DuckDB 2.0 added tr... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Connect 7779
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
..., query duckdb_settings() and filter on scope = 'LOCAL' ; search_path , schema , and the enable_profiling / profiling_mode family are common examples. Setting Options in the URL The same options can be appended to the JDBC URL, separated by semicolons.... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work