I agree with last statement. count(*) is not most important.
Most nice thing with index only scan is when it contains more than one
column.
When there is join among many tables where from each table only one or few
columns are taken
it take boost query incredibly.
For exmaple on when you have cust
Upps sorry now found it on TODO list.
I was not aware that it is SQL92 standard.
Is it difficult to implement ?
Simplest approach would be
to rewrite it to UPDATE t1 set col1 = (select cola ...), col2 = (select
colb)
but it would result in not optimal plan.
Marek Mosiewicz
be quite useful in another cases.
Would be it diffcult and possible to add such syntax to PostgreSQL ?
Marek Mosiewicz
http://www.jotel.com.pl
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
I'm looking for people who want to join OLE DB Provider project. It is
partially finished. I'm looking for people who want to help.
--
Marek Mosiewicz <[EMAIL PROTECTED]>
***r-e-k-l-a-m-a**
Chcesz oszczedzic na kosztach obslugi bankowej ?
mBIZNES - kon
I know that Apache Group created special library to handle difference
between different platforms (including win32). They had similar problems
porting Apache to Windows. They build very portable threads api (win32,
POSIX, native Linux thread and more) There is also all IPC stuff (mutex,
signals m
Do you know any attempts to write native OLE DB provider for PostgreSQL (it
would give broader support for VS Net). I would like to write such provider
and I want to know if sombody tried it before. Could somebody help me with
protocol issues (I have read Backend/Frontend Protocol and studied ODBC
