Postgresql Select from values in array -


i converting multiple rows in array using array_agg() function, , need give array select statements condition.

my query is,

select * table id =    all(select array_agg(id) table some_condition) 

but gives error, how can on come it..

the error has been cleared type casting array, using query this

 select * table id =      all((select array_agg(id) table some_condition)::bigint[]) 

reference link


Comments

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

monitor web browser programmatically in Android? -

c# - Using multiple datasets in RDLC -