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 <[email protected]> wrote:
> Hi Luís,
>
> On Thu, Jan 7, 2021 at 12:13 PM Luís Moreira de Sousa via grass-user
> [email protected] 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
</[email protected]>
_______________________________________________
grass-user mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-user
