Data dodania Pytanie
2016-11-18 23:11 How to get and compare the elements of the jsonb array in Postgres? »
Postgres 9.6.1 CREATE TABLE "public"."test" ( "id" int4 NOT NULL, "packet" jsonb, ) WITH (OIDS=FALSE) ; Jsonb {"1...
(1) odpowiedzi
2016-11-16 17:11 Save from params to JSONB datatype column using Postgres »
I'm kinda new working with JSONB datatype column and I'm having some trouble saving the data the way I'd like to my database in Ruby on Rails. I'd ...
(0) odpowiedzi
2016-11-16 09:11 Is ISO8601 the best date-format for PostgreSQL jsonb when i want to filter by the date? »
I'm new to PostgreSQL and I have the following question: I have a table with just an id-column and a data-column, which uses the jsonb-type. Inside t...
(2) odpowiedzi
2016-11-16 08:11 Search for a json array in jsonb column having data as json array in posgresql »
I have a jsonb column(gppermission) in my table doc which contains data as [{"Deny": "true", "Allow": "false", "GroupName": "Group 1 "}, {"Deny": ...
(1) odpowiedzi
2016-11-15 07:11 How to find the minimum value in a jsonb data using postgres? »
I have this jsonb data format- data {"20161110" : {"6" : ["12", "11", "171.00"],"12" : ["13", "11", "170.00"],"18" : ["16", "11", "174.00...
(1) odpowiedzi
2016-11-15 04:11 How to delete array element in JSONB column based on nested key value? »
How can I remove an object from an array, based on the value of one of the object's keys? The array is nested within a parent object. Here's a sampl...
(1) odpowiedzi
2016-11-14 13:11 ,column <columnName> is of type jsonb but expression is of type text[] »
Have array as below, needs to be saved in JSONB column: [{"FoodType":"veg","pref":"High"} ,{"FoodType":"sea food","pref":"Medium"} ,{"FoodType":"Chic...
(1) odpowiedzi
2016-11-14 08:11 Update multiple values in a jsonb data in postgressql »
I need to update a jsonb data(column->users) in my table 'settings' My jsonb data is like "{ "Email": "aaaa", "UserId": "49", "Created"...
(1) odpowiedzi
2016-11-11 06:11 rails_admin ActionView::Template::Error Only generation of json objects or arrays allowed »
I added this new migration on a really-working-well-with-no-errors rails_admin app add_column :my_table, :json_field, :json, null: false, default: '{...
(0) odpowiedzi
2016-11-09 08:11 index in query with subselect at jsonb array »
I have postgresql 9.4 table with jsonb array. create table test_path ( id bigint NOT NULL, path jsonb NOT NULL, CONSTRAINT test_chain PRIMARY K...
(0) odpowiedzi
2016-11-07 16:11 Injecting JSON parameter in nativeQuery of Spring JPA »
I have a table with a JSONB column. In my project I am using Spring JPA and to query that column I want to use nativeQuery. My problem is to inject va...
(0) odpowiedzi
2016-11-05 17:11 How to get size of posgresql jsonb field? »
I have a table with jsonb field in table. CREATE TABLE data.items ( id serial NOT NULL, datab jsonb ) How to get size of this field in a query ...
(0) odpowiedzi
2016-11-04 02:11 How to join jsonb array elements in Postgres? »
I am using Postgres 9.5, and I have the following tables: Users id UUID name TEXT Images id UUID key TEXT width INTEGER height INTEGER Posts ...
(1) odpowiedzi
2016-11-01 19:11 Spring Data Rest - PATCH Postgres jsonb field »
The short version is: How to patch the JSON object contained in a Postgres jsonb field using Spring Data Rest PATCH method? Here comes the long versi...
(0) odpowiedzi
2016-11-01 02:11 Json containment query »
I have a Postgres table containing json column like below: select * from jsontest; id | jbag ----+...
(1) odpowiedzi
2016-11-01 00:11 Why is this query taking so long on JSONB Gin index field? Can I fix it so it actually uses the index? »
Recently we changed the format of one of our tables from using a single entry in a column to having a JSONB column in the format of ["key1","key2","ke...
(1) odpowiedzi
2016-10-31 18:10 postgresql: jsonb update multiple keys in one query »
I have the following postgresql rows as JSONB row: {age:26} And I would like to replace it so that that i looks like this: {age: 30, city: "new yo...
(0) odpowiedzi
2016-10-31 17:10 Postgresaql (psycopg2) containment of jsonb: get all that do not have key field »
I have data that looks like this in jsonb format in postgresql: [ {assumed_title: "Moon Landing", "episode": 10}, {assumed_title: "Something else"} ]...
(0) odpowiedzi
2016-10-31 16:10 How can I create a custom hibernate dialect for the PostgreSQL jsonb operators? »
PostgreSQL added the ability to query json/jsonb type columns with operators like this: SELECT * FROM user u WHERE customerInfo @> :foo where cu...
(0) odpowiedzi
2016-10-27 21:10 PostgreSQL count results within jsonb array across multiple rows »
As stated in the title, I am in a situation where I need to return a count of occurrences within an array, that is within a jsonb column. A pseudo exa...
(1) odpowiedzi
2016-10-27 15:10 Remove jsonb array element by value »
I did figure out how to remove a value from an array for a single record, but how to do it for many of them. The problem is in the way how I use the s...
(3) odpowiedzi
2016-10-26 23:10 Why is this query taking so long? How can I fix it? Postgres 9.4 »
Recently we changed the format of one of our tables from using a single entry in a column to having a JSONB column in the format of ["key1","key2","ke...
(0) odpowiedzi
2016-10-26 11:10 Get all JSON keys efficiently on PostgreSQL »
Having a table create table tbl(data jsonb) I can select all keys that match a certain pattern from any object in the data column using select key...
(0) odpowiedzi
2016-10-25 07:10 Postgres select where jsonb array contains one or more elements in another array »
I've got a postgres column 'data' which is jsonb in this format: { 'tags': ['friend','enemy','frenemy'] ... // other data } Say I want to selec...
(1) odpowiedzi
2016-10-22 16:10 Query for exact json keys match in Postgresql (Exacly these keys) »
I'm trying to query after rows that contain a the keys ['kommune', 'fylke', 'år'] in a jsonb columns named data_filters. As far as i can see postgre...
(1) odpowiedzi
2016-10-21 23:10 Django PostgreSQL JSONField db_index error »
My model: from django.db import models from django.contrib.postgres.fields import JSONField class MyModel(models.Model): data = JSONField(blank=...
(1) odpowiedzi
2016-10-21 20:10 PostgreSQL JSONB Index for matching exact int key »
I have a table with column "times" that contain simple object { key(int): value(int), ... } { 1: 100, 2: 200, 3: 200, ... } Keys ar...
(0) odpowiedzi
2016-10-19 07:10 Select value of jsonb column in PostgreSQL »
I have a table 'Documents' which has a column 'Tags' with 'jsonb' datatype. Sample data in Tags column [{"Tag": "Social Media"}, {"Tag": "Adobe Cr...
(1) odpowiedzi
2016-10-19 01:10 Rails Postgres filtering for a jsonb object inside of a jsonb array »
Let's say I have a model Neighborhood that has a jsonb[] field families, which is an array containing json objects with any type of key value pairing ...
(1) odpowiedzi
2016-10-18 13:10 Indexing nested json with Postgres »
We have a table with a jsonb field with content like this: {"terms": { "foo": { "uri": "foo" }, "bar": { "uri": "bar" } } } We wou...
(1) odpowiedzi
2016-10-14 16:10 Save a Time object in JSONB »
I have a JSONB field in my database defined like this: t.jsonb :some_data, null: false, default: [] I've tried to save time objects to this field ...
(0) odpowiedzi
2016-10-14 12:10 Postgres: Range Query on nested jsonb column »
I am using postgres 9.5.4. From below sample json data stored in jsonb column, I would like to search records matching o['mid'] > 7000 This is s...
(1) odpowiedzi
2016-10-12 07:10 select or extract all key values inside a jsonb data in postgres »
I have a jsonb column in my postgres table and data is populated and stored in it. Here is a sample format of data that is stored in the jsonb column...
(1) odpowiedzi
2016-10-11 20:10 Wildcards in JSONB »
Looking for a wildcard operator to query JSONB data types. For example with this: $> Campaign.find(43).style_item_map {"0"=>{"items"=>[876,...
(1) odpowiedzi
2016-10-07 06:10 Get unique records where column type is JSONB »
I have a complicated Postgres query I'm trying to make, mainly because my columns / data is in the JSONB type. I need to get all records where Auth...
(1) odpowiedzi