Re: [SQL] Efficiency Problem

2013-03-17 Thread Surfing
From: Surfing Sent: 17/03/2013 12:16 To: pgsql-sql@postgresql.org <mailto:pgsql-sql@postgresql.org> Subject: [SQL] Efficiency Problem Hi all, I'm composing a query from a web application of type: *SELECT * FROM

Re: [SQL] Efficiency Problem

2013-03-17 Thread Misa Simic
@postgresql.org Subject: [SQL] Efficiency Problem Hi all, I'm composing a query from a web application of type: *SELECT * FROM table WHERE a_text_field LIKE replace_something ('%** a_given_string**%');* The function replace_something( ... ) is a stored procedure that replaces

[SQL] Efficiency Problem

2013-03-17 Thread Surfing
Hi all, I'm composing a query from a web application of type: *SELECT * FROM table WHERE a_text_field LIKE replace_something ('%**/a_given_string/**%');* The function replace_something( ... ) is a stored procedure that replaces some particular characters with others. The problem is that I