A
A
Andrew2019-02-05 14:16:43
PostgreSQL
Andrew, 2019-02-05 14:16:43

How to find records in Postgres that contain an object with a specific value?

There is a record of this kind in the database:
{name: 'a', contacts: {emal: '[email protected]', number: '123124124'}
} whose email is equal to a certain value?
I went through foreign resources, but did not find anything. The documentation is the same too.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2019-02-05
@melkij

If you have this correct json (or jsonb) and not what was shown:
If there is such a strange format, then write its parser.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question