Changeset 2187 for trunk/LATMOS-Accounts/lib/LATMOS
- Timestamp:
- 01/23/19 10:01:52 (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Netzone.pm
r2056 r2187 94 94 ( 95 95 select host(network(value::inet)+ (generate_series(0, broadcast(value::inet) - network(value::inet)))) from 96 netzone_attributes where attr='netExclude' and okey = $1 96 netzone_attributes where attr='netExclude' and okey = $1 and family(netzone_attributes.value::inet) = 4 97 97 union 98 98 select nethost_attributes_ips.value from nethost_attributes_ips join netzone_attributes on 99 99 netzone_attributes.attr='net' and nethost_attributes_ips.value::inet <<= netzone_attributes.value::inet 100 where netzone_attributes.okey = $1 100 where netzone_attributes.okey = $1 and family(netzone_attributes.value::inet) = 4 101 101 ) 102 102 ) as s … … 129 129 ( 130 130 select host(network(value::inet)+ (generate_series(0, broadcast(value::inet) - network(value::inet)))) from 131 netzone_attributes where attr='netExclude' and okey = $1 131 netzone_attributes where attr='netExclude' and okey = $1 and family(netzone_attributes.value::inet) = 4 132 132 ) 133 133 ) as s
Note: See TracChangeset
for help on using the changeset viewer.