[SQL] Can tsearch replace ilike queries ?

[Antony Paul]

Hi all,
I read in another thread about using tsearch for ilike queries. My
question is can it rprovide the full ilike functionality with a better
performance than ilike ?.

rgds
Antony Paul

---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] Maximum length of a query

[Antony Paul]

Hi all,
What is the maximum length allowed for a query in PG 7.3.3 ?. I
need arbitrarily long queries to be executed through JDBC.

rgds
Antony Paul

---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] How to know a temp table exists ?

[Antony Paul]

Hi all,
If using a connection pool how to know a temp table exists ?

rgds
Antony Paul

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings