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