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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only