Hi Markus, the label field was created by r.to.vect, I am not sure of its purpose. In the case of this particular record it is just an empty string (see below).
Thank you. s4a=# select * from mal9.mal9_5x5_sec_units where cat = 11133509 AND label IS NULL; cat | mal | label -----+-----+------- (0 rows) s4a=# select LENGTH(label) from mal9.mal9_5x5_sec_units where cat = 11133509; length -------- 0 (1 row) s4a=# \d+ mal9.mal9_5x5_sec_units Table "mal9.mal9_5x5_sec_units" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description --------+-----------------------+-----------+----------+---------+----------+--------------+------------- cat | integer | | | | plain | | mal | integer | | | | plain | | label | character varying(10) | | | | extended | | Indexes: "mal9_5x5_sec_units_cat" UNIQUE, btree (cat) Access method: heap -- Luís ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Thursday, January 7, 2021 9:46 PM, Markus Neteler <nete...@osgeo.org> wrote: > Hi Luís, > > On Thu, Jan 7, 2021 at 12:13 PM Luís Moreira de Sousa via grass-user > grass-user@lists.osgeo.org wrote: > > > Dear all, > > I have a mapset connected to a Postgres back-end: > > ... > > > select * from mal9.mal9_5x5_sec_units where cat = 11133509; > > > > ============================================================ > > > > cat | mal | label > > ----------+-----+------- > > 11133509 | 0 | > > (1 row) > > Just to be sure: "label" is ready empty here and does not contain a > spurious character with "funny" encoding not liked by DBMI? > > Best > Markus </nete...@osgeo.org> _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user