able WHERE id LIKE '%z%')
) WHERE expensivefunc(value) > 0.5;
or even
SELECT id, score FROM (
SELECT id, expensivefunc(value) AS score FROM (
(SELECT id, value FROM mytable WHERE id LIKE '%z%')
)
) WHERE score > 0.5
--
Orhan Kavrakoğlu
or...@tart.com.tr
Tart New Media
Hi all,
I've collected some interesting results during my experiments which I couldn't
figure out the reason behind them and need your assistance.
I'm running PostgreSQL 9.0 on a quad-core machine having two level on-chip
cache
hierarchy. PostgreSQL has a large and warmed-up buffer
cache thu
Hi,
Sorry in advance if this is the wrong list and the question has already been
posted. I'm a newbee in Postgres.
I would like to set the block size used in buffer cache to a specific value
which is greater than 32KB (let's say --with-block-size=256). Is there are way
to do that? Current vers
? In other words, does a java.sql.Statement
carry its own "session"?
Thanks,
Orhan
---(end of broadcast)---
TIP 6: explain analyze is your friend
