Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I select composite array element that satisfy specific conditions. - Mailing list pgsql-general

From David G. Johnston
Subject Re: How do I select composite array element that satisfy specific conditions.
Date
Msg-id CAKFQuwYTbGm84_2KVuCASrfP69UgvPQBCANtv7sG6r_tn-vxCw@mail.gmail.com
Whole thread Raw
In response to How do I select composite array element that satisfy specific conditions.  ("a" <372660931@qq.com>)
List pgsql-general
Tree view
On Wednesday, May 23, 2018, a <372660931@qq.com> wrote:
How could I select the element of Ay that satisfy x=3??


The note at the end of that section applies here though, you are forcing yourself to fight the nature of the relational database by not normalizing your data model.  Converting your array of composites to a table is going to make life considerably easier if you expect to have to performs searches like you requrest help for here.

David J.

pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: RE: RE: How do I select composite array element that satisfy specific conditions.
Next
From: Ron
Date:
Subject: Re: [GENERAL] Postgre compatible version with RHEL 7.5