[GRASSLIST:10371] Re: recent experiences

[Maciek Sieczka]

On Fri, 17 Feb 2006 09:48:57 +0100
"Radim Blazek" <radim.blazek at gmail.com> wrote:

> On 2/16/06, Maciek Sieczka <werchowyna at epf.pl> wrote:
> > Please note that using sqlite or postgres DB backends instead of dbf
> > might help you to reduce memory usage. Although sqlite looks
> > promising (easy to install and use, powerfull) there are issues
> > which hold me from recommending it (I'd love to use it myself):
> > 1. https://intevation.de/rt/webrt?serial_num=4056
> 
> select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2  and c1 ~
> 'bc' DBMI-SQLite driver error:
> Error in sqlite3_prepare():select c1 from grass_test1 where d1 <
> 500 / 2 and i1 <> 2  and c1 ~ 'bc'
> near "~": syntax error
> EXECUTE: ******** ERROR ********
> 
> '~' is not SQL standard, this is not a bug.

Good news. Thank you Radim.

Maciek

--------------------
W polskim Internecie s? setki milion?w stron. My przekazujemy Tobie tylko najlepsze z nich!
http://katalog.panoramainternetu.pl/