[postgis-users] How to test intersect of arrays which are created with generate_series in where clause?

[Shaozhong SHI]

I tried the following:

select * from a_table where (select
generate_series(pao_start_number,pao_start_number,1)) && array(select
generate_series(pao_start_number,pao_end_number,1) );

But, it did not work.

I do not know where went wrong.

Regards,

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210104/e85c66af/attachment.html>