Skip to main content
Database Administrators

Questions tagged [array]

Ask Question

An array is an ordered linear data structure consisting of a collection of elements (values, variables, or references), each identified by one or more indexes. When asking about specific variants of arrays, use related tags as well. When using this tag, in a question that is specific to a database, tag the question with the database being used.

323 questions
Newest Active Bountied Unanswered
1 vote
1 answer
141 views

I'm using an query to update a object array inside a jsonb column. Example data: [ { "_id": "68696e0a3aab2f9ff9c40679", "altura": 1, "comprimento":...
flourigh's user avatar
  • 145
2 votes
1 answer
137 views

How do I obtain the cardinality of a multirange? I'm using range_agg() to aggregate ranges, which merges ranges if they are continuous, or returns what looks like an array of ranges if the ranges are ...
Colin 't Hart's user avatar
  • 9,520
0 votes
2 answers
59 views

I have a table post_likes with one column being a post ID (uint), and another column being an array of IDs (uint[]) of users who liked the post. If I'm selecting info from multiple tables on multiple ...
bqback's user avatar
  • 107
0 votes
0 answers
116 views

I'm considering to use a composite type, array of standard type and array of composite type columns in TimescaleDB hypertable. I'm curious whether using such columns has any downsides like less ...
oliora's user avatar
  • 101
1 vote
1 answer
129 views

The Goal: Update an secondary table called Lottery_Cycle when an INSERT occours on table Lottery_History with some computed values and checking previous data. Let's say a lottery with 25 numbers of ...
Wisdom's user avatar
  • 11
-1 votes
1 answer
517 views

I have a table with an array of URLs in column urls. Now there's a need to update some URLs changing the hostname. E.g.: {https://storage.host1.com/file.jpg, https://storage.host1.com/file2.jpg} ...
minicooper's user avatar
  • 3
0 votes
1 answer
46 views

BigQuery has no native support for linear forecasting outside of machine learning, but it does support user-defined functions, and these can accept arrays as inputs. However, (as of 2023/10 anyway), ...
Jon of All Trades's user avatar
  • 5,985
0 votes
1 answer
90 views

I'm working with a table called price_options that has the following fields: id, slots, list_slots, and quantity. Issue Description My objective is to calculate the quantity for each price option ...
Khuzema's user avatar
  • 13

15 30 50 per page
1
2 3 4 5
…
22