Thanks for the extra feedback Merlin. I'll look into it a bit more,
JSONB obviously needs a bit of experimentation in the lab to get my
query syntax right !
On 27 January 2015 at 00:13, Merlin Moncure mmonc...@gmail.com wrote:
On Sun, Jan 25, 2015 at 6:50 AM, Tim Smith
On Sun, Jan 25, 2015 at 6:50 AM, Tim Smith
randomdev4+postg...@gmail.com wrote:
Doesn't meet my particular use-case exactly is not quite the same thing.
I would have thought my outlined use-case was pretty basic and common ?
It is. If your objects are always laid out in about the same way,
Doesn't meet my particular use-case exactly is not quite the same thing.
I would have thought my outlined use-case was pretty basic and common ?
On 23 January 2015 at 20:44, Christophe Pettus x...@thebuild.com wrote:
On Jan 23, 2015, at 12:20 PM, Tim Smith randomdev4+postg...@gmail.com
On Jan 23, 2015, at 7:40 AM, Tim Smith randomdev4+postg...@gmail.com wrote:
re: (a)
see the documentation pertaining to 'jsonb indexing', to wit:
-- Find documents in which the key company has value Magnafone
SELECT jdoc-'guid', jdoc-'name' FROM api WHERE jdoc @ '{company:
Magnafone}';
How does it not work?
In other words what was the query you tried and what was the output?
As in, it doesn't work. Full stop
\d+ json_test
Table public.json_test
Column | Type | Modifiers | Storage | Stats target | Description
On 01/23/2015 10:15 AM, Tim Smith wrote:
How does it not work?
In other words what was the query you tried and what was the output?
As in, it doesn't work. Full stop
\d+ json_test
Table public.json_test
Column | Type | Modifiers | Storage | Stats target |
On Jan 23, 2015, at 12:20 PM, Tim Smith randomdev4+postg...@gmail.com wrote:
So basically we're saying JSON in 9.4 is still a little way from where
it needs to be in terms of real-world functionality ? Or am I being
too harsh ? ;-)
Doesn't meet my particular use-case exactly is not quite
So basically we're saying JSON in 9.4 is still a little way from where
it needs to be in terms of real-world functionality ? Or am I being
too harsh ? ;-)
On 23 January 2015 at 18:49, Adrian Klaver adrian.kla...@aklaver.com wrote:
On 01/23/2015 10:15 AM, Tim Smith wrote:
How does it not work?
create table json_data(row_id int, json_text jsonb);
insert into json_data(1,
'[{ID:1,location_name:Test},{ID:2,location_name:Examples}]');
To search for an ID
select row_id, parsed.* from json_data, lateral
jsonb_to_recordset(json_data.json_text) as parsed(ID text, location_name
text) where
Hi,
I've tried RTFMing on the wonderful new 9.4 jsonb features, but
there's a little bit of a lack of examples as to how to do stuff.
I've got a document loaded in to a jsonb column that looks something like :
[{ID:1,location_name:Test},{ID:2,location_name:Examples}]
Anyway, there are a few
On 01/23/2015 07:40 AM, Tim Smith wrote:
re: (a)
see the documentation pertaining to 'jsonb indexing', to wit:
-- Find documents in which the key company has value Magnafone
SELECT jdoc-'guid', jdoc-'name' FROM api WHERE jdoc @ '{company:
Magnafone}';
Nope, sorry, tried that. Doesn't work
re: (a)
see the documentation pertaining to 'jsonb indexing', to wit:
-- Find documents in which the key company has value Magnafone
SELECT jdoc-'guid', jdoc-'name' FROM api WHERE jdoc @ '{company:
Magnafone}';
Nope, sorry, tried that. Doesn't work for me. Hence the question. ;-)
On 23
On Fri, Jan 23, 2015 at 8:00 AM, Tim Smith
randomdev4+postg...@gmail.com wrote:
Hi,
I've tried RTFMing on the wonderful new 9.4 jsonb features, but
there's a little bit of a lack of examples as to how to do stuff.
I've got a document loaded in to a jsonb column that looks something like :
13 matches
Mail list logo