Data dodania Pytanie
2017-10-10 16:10 how to update JSONB column using knexjs, bookshelfjs »
I have a JSONB column in PostgreSQL database like {lat: value, lon: value}. I want to change any specific value at a time eg. lat, but I am not sure h...
(1) odpowiedzi
2017-10-10 09:10 Inner join with postgres array field »
We have a CMS using rails,react and postgresql. We have pages and pieces stored in our table. Each page consist of a set of pieces (An array field). ...
(1) odpowiedzi
2017-10-10 01:10 postgres index optimization jsonb »
I am on postgres 9.5. I have a table which is as below CREATE TABLE public.info ( metadata jsonb, state text, active boolean name tex...
(0) odpowiedzi
2017-10-06 20:10 How to use postgres jsonb operator '?' in laravel 5 »
I'm trying to run a query with jsonb ? operator https://www.postgresql.org/docs/9.6/static/functions-json.html. In database console its ok, but i can...
(0) odpowiedzi
2017-10-04 18:10 PostgreSQL - NoSQL query ideas to select one node of JSON »
I have this JSON on my database: { "Id": 1, "Questions": [ { "QuestionId": 6, "Description": "Question 1", ...
(1) odpowiedzi
2017-10-04 00:10 Using submodel accessor (STI) on parent params for nested forms »
i have the following models: class Order < ApplicationRecord class Bill < Order class Preorder < Order class Detail < ApplicationRecord ...
(1) odpowiedzi
2017-10-02 11:10 Migrating PSQL table to jsonb without null values »
I have to migrate table which contains key and multiple values in columns(nullable) into jsonb represented key value postgres table. K | V1 | V2 | V3...
(2) odpowiedzi
2017-09-29 16:09 Returning JSON from Postgres is slow »
I have a table in Postgres with a JSONB column, each row of the table contains a large JSONB object (~4500 keys, JSON string is around 110 KB in a txt...
(1) odpowiedzi
2017-09-29 05:09 Converting this text to jsonb? »
I have this text: ("{""A"":""0/000"",""B"":2}") I want to convert it to a jsonb like this: {"A":"0/000","B":2} How do I do this? ...
(1) odpowiedzi
2017-09-26 12:09 SQLAlchemy, there is not history of deleted state of JSONB field »
For example I have a model: class AttributeValue(db.Model): id = Column(Integer, primary_key=True) value = Column(JSONB(), nullable=False) ...
(1) odpowiedzi
2017-09-23 01:09 How to insert JSONB into Postgresql with Python? »
I am new to python and postgresql I've been battling just hardcoding each json line with python and I don't think this the scalable method. If someo...
(2) odpowiedzi
2017-09-21 17:09 How to reject deserialization of unrecognized with JSON-B »
I am attempting to migrate the implementation details of some JSON databinding code to use the Java EE 8 JSON-B APIs instead of Jackson. In order to ...
(0) odpowiedzi
2017-09-21 15:09 Postgresql unique constraint for jsonb array »
I am new to postgresql. I want to make the unique constraint in jsonb array. I need to save data in given formats {"data":[{"lan_id":"da315627-3ece-2...
(0) odpowiedzi
2017-09-20 00:09 How to query jsonb array of hash elements for missing key/value pair in Rails 5/Postgres »
I have a jsonb array attribute (array_attr) on a class (Klass) in my Rails 5 app. The array is an array of hashes. Some of the hashes contain keys tha...
(1) odpowiedzi
2017-09-19 08:09 How to Store List of Java Objects/Json into Postgres Jsonb using JPA? »
How do we define List of objects into postgres 9.6 jsonb data type using JPA? I'm trying to put list of products into order table's products column wh...
(0) odpowiedzi
2017-09-18 11:09 How to query PostgreSQL nested JSONB in deeper level? »
I'm new to JSON/JSONB datatypes and I'm having some problems selecting the JSONB elements from deeper levels. Here is an example table: CREATE TABLE...
(1) odpowiedzi
2017-09-17 16:09 How do you pass json to a parameterized sql statement using psycopg2? »
What's the correct syntax to pass json into a parameterized SQL statement? How do you safely pass a variable into the json along with it? I ha...
(0) odpowiedzi
2017-09-16 23:09 Using Bookshelf to execute a query on Postgres JSONB array elements »
I have a postgres table with jsonb array elements and I'm trying to do sql queries to extract the matching elements. I have the raw SQL query running ...
(1) odpowiedzi
2017-09-16 21:09 Postgres query records where any element in array of objects in JSONB field contains number > or < x »
I've searched around but this seems to be a more unique requirement for querying JSONB fields than is common and haven't found a solution yet. My tabl...
(1) odpowiedzi
2017-09-15 11:09 AND clause to assert boolean value JSONB »
I have a JSONB query that checks to see if an ID is in an array within my column. I also have a boolean in my JSON I want to check in an AND clause. I...
(0) odpowiedzi
2017-09-15 02:09 Find model based on jsonb nested data field »
I use Ruby on Rails and Postgres 9.5. In the database I have a table called events. I want to find all events based on particular value in the data ...
(1) odpowiedzi
2017-09-14 10:09 Is there a way to generate columns in a view based on table row data? »
I have this table which contains the settings of an app & I just want to show it in the view. The data of each setting is stored as a row. Code (...
(1) odpowiedzi
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