Data dodania Pytanie
2017-09-13 17:09 Query jsonb array for integer member »
Background: We use PaperTrail to keep the history of our changing models. Now I want to query for a Item, which belonged to a certain customer. PaperT...
(2) odpowiedzi
2017-09-12 14:09 PostgreSQL json aggregation issue »
How with Postgres aggregation function merge one object as element in array field in parent object. What need Sector Project Result My SQL...
(0) odpowiedzi
2017-09-12 13:09 Long Response times Retrieving JSON from Postgres »
We are currently facing an issue where we are trying to retrieve a number of records from an 'orders' table which contains a few columns (store number...
(0) odpowiedzi
2017-09-11 21:09 How to retrieve all the rows in postgres where values of a jsonb key is greater then an int value? »
I'm new to postgres, so if this is newbie question, please redirect me. I'm trying to retrieve all the rows where the value is greater then 0. This i...
(1) odpowiedzi
2017-09-08 11:09 Sequelize create index on JSONB attribute »
How do I create an index using sequelize's syntax for a JSONB field in postgres? The index I want to create in SQL would be: CREATE INDEX people ON ...
(1) odpowiedzi
2017-09-06 20:09 Use key values from JSONB nested object in Postgres query »
I have a query that is working but I need to use an internal key value from a nested value to dynamically change the JSON path in my select query to r...
(0) odpowiedzi
2017-09-06 00:09 Postgre Convert column jsonb in another table where the columns are the keys »
I need to create an script using python in this case to take a column jsonb of one table an create another table where the columns are all possible ke...
(1) odpowiedzi
2017-09-04 06:09 Rails 5 search jsonb nested array for date between 2 other dats »
I'm trying to craft a query for searching a jsonb field in Ruby on Rails 5, I need to find all records that have an occurrence that is inside a date r...
(1) odpowiedzi
2017-09-03 21:09 How to insert JSONB using SQLAlchemy's 'execute'? »
I need to run a function that takes an integer and JSONB data. In a normal console, I would run it like this: select my_func(0, '{"foo": "bar"}'::jso...
(1) odpowiedzi
2017-09-02 17:09 jsonb vs jsonb[] for multiple addresses for a customer »
It's a good idea to save multiple addresses in a jsonb field in PostgreSQL. I'm new in nosql and I'd like to test PostgreSQL to do that. I don't want ...
(1) odpowiedzi
2017-09-02 00:09 Fuzzy string match in postgres jsonb column »
I have a jsonb column in a postgres table called topics which is a literal array of strings. An example record might have this for a topics value: [...
(1) odpowiedzi
2017-09-01 19:09 Postgres 9.4+ jsonb: Index dictionaries nested in arrays »
Given a table create table tmp (data jsonb not null); and data insert into tmp (data) values ('{"root": [{"name": "item1"}, {"name": "item2"}]}');...
(1) odpowiedzi
2017-09-01 10:09 last given value before a specific date from a JSONB-column »
I want to get the last given value before a specific date(in this case 2015-09-30) from a BD with on id and 2 JSONB-column that looks like this: 1, ...
(1) odpowiedzi
2017-09-01 07:09 Postgres: Why do smaller JSON documents take more disk space than a larger ones? »
I am testing how much storage space JSON documents, stored as JSONB in Postgres 9.6.4, would take for our application. The tests produced odd results...
(0) odpowiedzi
2017-08-31 09:08 Counting the occurrences of distinct values in a column »
I have the following query: select jsonb_build_object('high', count(*) filter (where total = 'High')) || jsonb_build_object('medium', count(...
(1) odpowiedzi
2017-08-30 15:08 PostgreSQL - grouping by jsonb column »
I have survey_results table which has following columns: id - integer score_labels - jsonb score_labels column data format looks like this: {"tot...
(1) odpowiedzi
2017-08-30 14:08 Search for value at a specific time in jsonb i postgres »
I'm trying to pick out a value at a specific time from a jsonb column in postgres and tried to apply the answer from this tread but can't make it work...
(0) odpowiedzi
2017-08-28 18:08 How to load data as nested JSONB from non-JSONB postgres tables »
I'm trying to construct an object for use from my postgres backend. The tables in question look something like this: We have some Things that essenti...
(1) odpowiedzi
2017-08-28 16:08 jsonb-search to only show the spec value »
I found most of you questing in this tread but I have problem to get the right bit out of my query, The jsonb-column looks like this: [ {"price": 6...
(1) odpowiedzi
2017-08-28 16:08 Rails jsonb search in all attributes »
I have a jsonb field in my postgres database that contains some user info, and I have a search box in my app which query the jsonb field, if for examp...
(0) odpowiedzi
2017-08-25 17:08 Accessing current row values in a trigger »
I created a function will insert a value into a json for each row inserted in a table. But when I execute the insert, it says me that the column does...
(1) odpowiedzi
2017-08-24 08:08 How to extract a specific object inside an jsonb column using postgres »
My Jsonb column looks something like this: table name:jsonb and column name:json_test [ { "run_id": "EXE20170822172151192", "user_id": "12...
(1) odpowiedzi
2017-08-23 21:08 @JsonIgnore field in frontend UI and include it in Jsonb json serialization to store in Postgres »
I need a field to be ignored in front end UI, whereas the same field will be calculated in backend and needs to get stored in Postgres DB as a Jsonb o...
(1) odpowiedzi
2017-08-22 06:08 How to make Odoo support to Postgres JSONB field »
PostgreSQL supports NoSQL feature with JSONB. How can I use it in odoo? ...
(1) odpowiedzi
2017-08-21 11:08 How to use the key of jsonb in postgresql as a row value? »
I have a table like this: id (serial) | data (jsonb) 1 | {"a": 1, "b": 2} 2 | {"a": 3, "b": 1} how to convert it to this table:...
(1) odpowiedzi
2017-08-19 15:08 PostgreSQL JSONB versus keeping a separate table »
I'm thinking through a database design and I was wondering if anyone could chime in. I have some structured data that I will occasionally be filtering...
(0) odpowiedzi
2017-08-18 06:08 Accepts nested attributes safe params with jsonb and variable keys »
I am attempting to allow parameters to go through my controller for a data attribute that is of type jsonb, the hash looks like so: data: { "en" =...
(1) odpowiedzi
2017-08-17 17:08 Creating custom user types for jsonb columns in hibernate postgresql »
I am trying to migrate my spring mvc project database from mongodb to postgresql. Spring version 4.3.8.RELEASE Hibernate version 5.2.10.Final Postgres...
(0) odpowiedzi
2017-08-16 08:08 Querying an array within an array with Postgres JSONB query »
I have some JSON in a field in my Postgres 9.4 db and I want to find rows where the given name is a certain value, where the field is named model and ...
(1) odpowiedzi
2017-08-15 23:08 How to pass value from temp table to jsonb query in psql »
I have following temp table with just one row of data in psql idx | state| dir ----+-------+---------- 1 | TX | 123 I need to pass this ...
(0) odpowiedzi
2017-08-15 14:08 Searching jsonb column by array of value »
In my Ruby on Rails project I have SurveyResult model with the following scope: class SurveyResult < ActiveRecord::Base scope :with_purpose, -&g...
(1) odpowiedzi
2017-08-14 20:08 How to implement full text search on complex nested JSONB in Postgresql »
I have pretty complex JSONB stored in one jsonb column. DB table looks like: CREATE TABLE sites ( id text NOT NULL, doc jsonb, PRIMARY KEY...
(0) odpowiedzi
2017-08-14 20:08 How to write this query using active record query interface? »
I have products table with jsonb type specs column. One of the keys in this json is brand. I can successfully run query like this: SELECT specs -&gt...
(1) odpowiedzi
2017-08-13 16:08 Extract and expand Postgres JSON column data into separate table »
There is a Postgres 9.6 table with these columns: targettable ------------------------------------------------------------------ id | name | jsonbda...
(1) odpowiedzi
2017-08-09 10:08 recursively flatten a nested jsonb in postgres without unknown depth and unknown key fields »
How can I recursively flatten a nested jsonb in postgres which I don't know the depth and the field at each depth? (see example below) A postgressql ...
(1) odpowiedzi