[GRASSLIST:3784] Re: Fun with dbf in GRASS57

[Radim Blazek]

On Wednesday 30 June 2004 07:25, Michael Barton wrote:
> > Hello,
> > I want to select some areas from a vector map connected to a dbf file.
> > The
> > wanted area must match a given string pattern, but I can't get passed
> > this
> > message:
> >
> > DBMI-DBF driver error:
> > SQL parser error in statement:
> > SELECT * FROM NHD_HU11d WHERE HUC_11 LIKE '02040101%'
>
> The GRASS SQL implementation doesn't use the operator 'like' (It also
> doesn't use 'in')
>
> > Could anybody point me to some generic references about what a dbf
> > server can
> > or cannot do, and how easy is it to switch to another driver (seems
> > that I'll
> > have to use postgresql eventually...)
>
> I had a similar question and Radim pointed me to this brief but useful
> guide in the GRASS 5.7 manual. Here is the address for the on-line
> version.
>
> <http://grass.itc.it/grass57/manuals/html57_user/sql.html>

It should be called 'Subset of SQL implemented in dbf driver'
or something like that.

WHERE HUC_11 ~ '02040101%'
could work.

Radim