Posts by Clara Magalhaes • 25 points
4 posts
-
0
votes0
answers11
viewsQ: How to create a materialized view by creating a unique id
I need to create a materialized view, and I need to create a unique id within that view: I have a square table with the geometry of the court (which have unique id). I’m crossing the geometry of…
postgresqlasked Clara Magalhaes 25 -
1
votes1
answer57
viewsQ: Postgresql: How to select a field based on the maximum value of another field?
I have a table with the following configuration: create table baixas_do_requerimento as codigo_requerimento text, tipo_baixa text, data_baixa timestamp Each código_requerimento can repeat numerous…
-
0
votes1
answer167
viewsQ: Mask to turn integer into string - Postgresql
Good morning! I am trying to implement a mask on an integer number, whose output will be a string with embedded characters. I would like the user to enter only 12 integer digits and the database to…
postgresqlasked Clara Magalhaes 25 -
1
votes0
answers20
viewsQ: Postgresql: Intersection between polygons returns lines and points
I am working on a spatial query and have two tables with features of Geometrytype ONLY Polygon or Multipolygon: ZONING TABLE: select ST_GeometryType (geom), count (*) from…
postgresqlasked Clara Magalhaes 25