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
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