Just for the record, try:

select * from postcode where m.addr $ address m.addr

It might be a little faster...

Be careful, this is case sensitive.

Vlad

>I have two sql statement:
>select * from postcode where ascen(addr_array,address)
>This take several seconds each time.
>
>The other sql statement:
>select * from postcode where atc(address,m.addr)#0
>also take several seconds.
>
>I want it take up to one second only, any suggestions?