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

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(`fnam

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: > u

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