Hello Jarek, please re-run Your gis.m with DEBUG=3 g.gisenv set=DEBUG=3 then redraw map and look into output pane for line: D3/3: db_select_int() D3/3: SQL: SELECT cat FROM ... and post result here. Ignore other error messages, that will popup.
Maris. 2008/10/29, Jarek Jasiewicz <[EMAIL PROTECTED]>: > Hi > Well, I thing I expect too much, but for now grass has been suprising me > (positively) on cooperation GRASS - POstgreSQL > > I have a query which works well in PgAdmin: > > SELECT cat FROM streams_coor WHERE link::text IN( > SELECT regexp_split_to_table( > (SELECT branch FROM links WHERE keyid='168'), E'\\.')) > > the branch looks like this: > "89.88.166.169.168" > > and result are: > > 148 > 150 > 161 > 168 > 157 > > > > If I try to use this query in gis.m "use sql query" field with proper > SQL syntax" > > link::text IN( > SELECT regexp_split_to_table(( > SELECT branch FROM links WHERE keyid='168'), E'\\.')) > > > do not receive any error but also any result > > so where is problem? > > As far as I know GRASS simply send query to database and recive list of > cats as a result, so there could be the problem with parsing quotemarks > and escape marks in regular expresion? > > regards > Jarek > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user > _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
