well, i just tried it on oracle 8i as well and it doesn't work there
either, so i'm going with the theory that the CF people are just on crack
"go back to your homes citizens, nothing to see here"
-duck
> haven't seen use of 'left()', but you could use substr() ...
>
> On Tue, 2 Jan 2001, D. Duccini wrote:
>
> >
> > select * from speakers where left(speaker_last_name,1) >= 'N';
> >
> > which psql doesn't like
> >
> > is this really SQL standard or really an oracle thing?
> >
> > i know you can do a better job with
> >
> > select * from speakers where speaker_last_name ~* '^N';
> >
> > the only reason I'm concerned is that our webmaster is working to
> > integrate ColdFusion apps with PSQL (which work great) however, she's a
> > real SQL novice (had to show her how to setup a sequence to map over to MS
> > Access 'auto' datatype) et al
> >
> >
> >
> >
> > -----------------------------------------------------------------------------
> > david@backpack.com BackPack Software, Inc. www.backpack.com
> > +1 651.645.7550 voice "Life is an Adventure.
> > +1 651.645.9798 fax Don't forget your BackPack!"
> > -----------------------------------------------------------------------------
> >
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
-----------------------------------------------------------------------------
david@backpack.com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------