Hi Abdul,
You may have lost the '' around the date specification in the to_char function when
forming the string in Java. Before submitting the query, check the contents of the
query string to make sure you still have the '' marks.
Regards,
David Witham
-Original Message-
From: Abdul W
I wrote a java program to query a data from 4 tables and the string
query is like:
querydata ="select
bizfavorite.bizid,bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype,"
+ "bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-') as
listdate,bizfavorite.offe
I have a table with 8,628,633 rows that I'd LIKE to search (ha ha).
I have a very simple query:
SELECT * FROM tableA WHERE column1 LIKE '%something%';
tableA.column1 has an index on it and the database has been vacuumed recently. My
problem is with the output of EXPLAIN:
+
[EMAIL PROTECTED] writes:
> I'm currently developing a database in which I have a list of
> drivers. I've written a stored procedure for MS SQL Server
This list is not for discussing MS SQL. Please direct your question
to a more approriate forum.
regards, tom lane
--
