On Tue, 17 Sep 2002, Chisel Wright wrote: > On Tue, Sep 17, 2002 at 11:04:53AM +0000, Rafiq Ismail (ADMIN) wrote: > > SELECT substr(content,11, 15) AS fish FROM FOO where fish='fish' > That didn't work when I tried it: > > chisel=# select substring(content from 11 for 4) as fish from FOO where fish = >'post'; > ERROR: Attribute 'fish' not found 'tis true. :)
> chisel=# select substring(content from 11 for 4) as fish from FOO where >substring(content from 11 for 4) = 'post'; > +------+ > | fish | > +------+ > | post | > +------+ Thanks.