On Fri, 17 Aug 2007, Tyson Lloyd Thwaites wrote:
It looks like it would be best if we re-worked our transactions and controlled them manually for the portions that need it.
I am glad you have moved so quickly through grief and into acceptance.
It is still a possible point of confusion, but I am starting to think that pgsql has it right, and mssql has it wrong. (I feel betrayed!) This issue probably deserves a prominant place in the FAQ!
In whose FAQ? Would need more details about what MS-SQL is doing badly to cover it on this side of things. There's been some collecting of trivia in that category lately, haven't gotten to issues with their product much so far.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
