---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Thu, Oct 23, 2003 at 14:17:08 -0400,
[EMAIL PROTECTED] wrote:
>
> I can't do the following, since the number of selected columns have to match:
One option is to use where NOT EXISTS instead of EXCEPT. Another way would
be to add A.id to the rows in the set difference using a join. I expect
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] transmitted:
> SELECT min(inserttime) FROM acc_pb; which takes about 11 seconds to
> complete.
>
> On the mssql server this takes less than 1 second.
If you have NO index on inserttime, then the best that can be done is
the se
Hello,
I have a table that contains logs from a radius accounting server.
Currently the table contains 1,780,470 rows and is about 350Mb on the disk.
It is running on a mssql server at the moment but I would like to move it
over to a postgresql server and postgresql seems to be somewhat fast than
Hello,
I am looking for a way that I can define a constant in PostgreSQL (so that
I end up with a constant similar to one that I could have in Oracle). I have
searched the archives and it seems that the solutions that were suggested in
include creating a table of constants or alternatively creatin
