Re: [SQL] interesting SQL puzzle - concatenating column with itself.

2005-05-10 Thread PFC
BTW the concatenation function you suggest works nicely except that as you noted, it concatenates in an unpredictable order, so I'm now trying to solve that problem. memo_id | sequence | memo_text --- 666 | 1| The quick 666 | 2| r

Re: [SQL] interesting SQL puzzle - concatenating column with itself.

2005-05-10 Thread Nick Fankhauser
Alvaro Herrera wrote: The order is not really guaranteed, though if this is a one-shot thing, you may get away with turning off hashed aggregates. When I read this, I assumed there was a runtime parameter I could set that was similar to ENABLE_HASHJOIN. Are you referring to a different runtime p

[SQL] unsuscribe

2005-05-10 Thread joffer
unsuscribe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])