.
Maybe I missed something from your example?
On Wed, Jun 21, 2017 at 12:27 AM, Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> On 21/06/2017 01:01, Emilie Laffray wrote:
>
>> Hello,
>>
>> I have been playing with Postgresql recently with a large table an
ot;:1,"rank":1,"label":2}]'
Effectively, I would want to extract the value corresponding to my
condition using simple SQL aka not having to write a function extracting
the json.
The experiment on the second data structure shows that it is not as
convenient as I may need to perform search on either type, label, rank and
various combinations of the fields.
Am I missing something?
Thanks in advance,
Emilie Laffray
.
Emilie Laffray
Richard Huxton wrote:
Emilie Laffray wrote:
3) I have an antivirus running, but again this antivirus has been
running for months and I have worked on postgresql also for months.
There has been an update yesterday to that antivirus, but I don't think
it had an impac
space is not a problem with more than 160GB free.
I tried also in the meantime to run a vacuum, and I got some messages
that the indexes had a problem and it was working to fix it. It crashed.
I restarted my pc and could perform the vacuum just fine afterwards.
Richard Huxton wrote:
E
TW';
UPDATE gtable AS g
SET code = '00' -- 04
WHERE g.d IN (6724652, 1673813);
Those two queries do exactly the same thing but they both crash with
the same information, except for the length between the two queries.
What should I do?
Emilie Laffray
--
Sent via pgsql-
