Postgres Pro
Downloads
Home   >   mailing lists

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

From a
Subject How do I select composite array element that satisfy specific conditions.
Date
Msg-id tencent_56F57B4C4E55B65B7DE43183@qq.com
Whole thread Raw
Responses RE: How do I select composite array element that satisfy specific conditions.  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Re: How do I select composite array element that satisfy specific conditions.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi, say if I have composite type and table 

create type A as(
     x float8,
     y float8
);

create table B(
     Ay A[]
);

insert into B
values(array[
     (1,2)::A,
     (3,4)::A]
);

How could I select the element of Ay that satisfy x=3??

Thank you so much!!

Shore

pgsql-general by date:

Previous
From: tango ward
Date:
Subject: Insert data if it is not existing
Next
From: Steven Winfield
Date:
Subject: RE: Insert data if it is not existing