learning to understand compress function

2005-05-11 Thread Steve Buehler
I am trying to figure something out about the compress function. If I wanted to compress a field in a column/row and write it back to the table, how can I do this? Is it possible to do it in one command? I tried: update `conflicts` set `fname`=(SELECT compress(`fname`) FROM `conflicts` WHERE

Re: learning to understand compress function

2005-05-11 Thread SGreen
Steve Buehler [EMAIL PROTECTED] wrote on 05/11/2005 09:36:44 AM: I am trying to figure something out about the compress function. If I wanted to compress a field in a column/row and write it back to the table, how can I do this? Is it possible to do it in one command? I tried: update

Re: learning to understand compress function

2005-05-11 Thread Jigal van Hemert
From: Steve Buehler I am trying to figure something out about the compress function. If I wanted to compress a field in a column/row and write it back to the table, how can I do this? Is it possible to do it in one command? I tried: update `conflicts` set `fname`=(SELECT compress(`fname`)

Re: learning to understand compress function

2005-05-11 Thread Steve Buehler
At 08:50 AM 5/11/2005, you wrote: Steve Buehler [EMAIL PROTECTED] wrote on 05/11/2005 09:36:44 AM: I am trying to figure something out about the compress function. If I wanted to compress a field in a column/row and write it back to the table, how can I do this? Is it possible to do it in