Re: RE: RE: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread David G. Johnston
On Wed, May 23, 2018 at 6:50 AM, a <372660...@qq.com> wrote: > > That is only by saying, the actual information could be much more, and all > of them are not in some way, "aligned". > ​Not sure what you are getting at here - "related" is generally the better term and usually during modeling one o

Re:RE: RE: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread a
d again, thanks for answering my questions. -- Original -- From: "Charles Clavadetscher";; Date: May 23, 2018 To: "a"<372660...@qq.com>; "'pgsql-general'"; Subject: RE: RE: How do I select composite array elemen

Re: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread David G. Johnston
On Wednesday, May 23, 2018, a <372660...@qq.com> wrote: > > How could I select the element of Ay that satisfy x=3?? > https://www.postgresql.org/docs/10/static/arrays.html#ARRAYS-SEARCHING The note at the end of that section applies here though, you are forcing yourself to fight the nature of th

RE: RE: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread Charles Clavadetscher
Hello From: a [mailto:372660...@qq.com] Sent: Mittwoch, 23. Mai 2018 14:23 To: Charles Clavadetscher ; pgsql-general Subject: Re: RE: How do I select composite array element that satisfy specific conditions. Thanks for your reply... Honestly I do not use java and don't r

Re: RE: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread a
json would be helpful on creating a relative efficient mechanism on that.. ---Original--- From: "Charles Clavadetscher" Date: Wed, May 23, 2018 19:29 PM To: "'pgsql-general'";"'a'"<372660...@qq.com>; Subject: RE: How do I select composite

RE: How do I select composite array element that satisfy specific conditions.

2018-05-23 Thread Charles Clavadetscher
Hi > -Original Message- > From: a [mailto:372660...@qq.com] > Sent: Mittwoch, 23. Mai 2018 11:43 > To: pgsql-general > Subject: How do I select composite array element that satisfy specific > conditions. > > Hi, say if I have composite type and table > > create type A as( > x floa