Re: [GENERAL] Planner hints in SELECT queries?

2008-12-17 Thread Tom Lane
"Dmitry Koterov" writes: > I propose to add the SELECT clause to do it natively, like this: > SELECT * > FROM tbl > ORDER BY id > LIMIT 10 > SETTING something=off, other=off Use a function with a SET clause attached. regards, tom lane -- Sent via pgsql-general mailing

[GENERAL] Planner hints in SELECT queries?

2008-12-17 Thread Dmitry Koterov
Hello. Sometimes I have to create the following SQL code: SET something=off; SET other=off; SELECT * FROM ... ORDER BY id LIMIT 10; RESET something; RESET something; (e.g. "something" may be equal to "seq_page_cost=10"). I propose to add the SELECT clause to do it natively, like this: SELE