Re: ColdFusion sez this is valid SQL - Mailing list pgsql-novice

From Poul L. Christiansen
Subject Re: ColdFusion sez this is valid SQL
Date
Msg-id 3A53365D.66A1C47B@cs.auc.dk
Whole thread Raw
In response to Re: ColdFusion sez this is valid SQL  ("D. Duccini" <duccini@backpack.com>)
Responses Re: ColdFusion sez this is valid SQL
List pgsql-novice
Hmmmm, I don't know excatcly what you are trying to do, but I don't think you can use
the Cold Fusion function Left.

Try using the PostgreSQL function substr() instead, as someone else suggested.

Poul L. Christiansen

"D. Duccini" wrote:

> doesn't work either
>
> ERROR:  parser: parse error at or near "left"
>
> at least not under 6.5.3
>
> On Wed, 3 Jan 2001, Poul L. Christiansen wrote:
>
> > Try:
> > "select * from speakers where #left(speaker_last_name,1)# >= 'N'"
> >
> > You forgot the # signs ;-)
> >
> > Poul L. Christiansen
> >
> > "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!"
> > > -----------------------------------------------------------------------------
> >
>
> -----------------------------------------------------------------------------
> 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!"
> -----------------------------------------------------------------------------


pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: ColdFusion sez this is valid SQL
Next
From: "D. Duccini"
Date:
Subject: Re: ColdFusion sez this is valid SQL