Hi Postgres fans,
We store a Java Map in Postgres as a jsonb column.
As json does not have a UUID type, it is of course stored as text.
A simple value might be:
{"04e623c0-6940-542f-a0de-4c999c626dfe": 5000,
"6d3e24b6-9e8c-5eb1-9e4c-f32cc40864c9": 20825}
I am trying to implement an effi
> On Apr 26, 2019, at 2:33 PM, Rob Sargent wrote:
>
>
> On 4/26/19 3:25 PM, Steven Schlansker wrote:
>>
>>
>> How can I efficiently implement the feature I've described? It seems
>> difficult to use computed indexing with GIN.
>>
> Sto
> On Apr 27, 2019, at 12:55 AM, Andrew Gierth
> wrote:
>
> Obvious solution:
>
> create function uuid_keys(mapData jsonb) returns uuid[]
> language plpgsql immutable strict
> as $$
>begin
> return array(select jsonb_object_keys(mapData)::uuid);
>end;
> $$;
>
> create index on
