Skip to main content
Geographic Information Systems

Return to Question

naming
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

Trigger spatial join on isertinsert and update

i'veI've a problem with a trigger in postgresPostgreSQL. iI can do the query but iI don't know to developmentdevelop a trigger. theThe example query is:

select schemaA.table1.value
from schemaB.table2
on
st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me pleaseHow can I do this?

Best

Trigger spatial join on isert and update

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value
from schemaB.table2
on
st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?

Best

Trigger spatial join on insert and update

I've a problem with a trigger in PostgreSQL. I can do the query but I don't know to develop a trigger. The example query is:

select schemaA.table1.value
from schemaB.table2
on
st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

How can I do this?

added 16 characters in body
Source Link
J.R
J.R
  • 17.4k
  • 2
  • 23
  • 55

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value from schemaB.table2 on st_contains(schemaB.table2.geom,schemaA.table1.geom)

select schemaA.table1.value
from schemaB.table2
on
st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?

Best

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value from schemaB.table2 on st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?

Best

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value
from schemaB.table2
on
st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?

Best

Source Link
GIOVA.A88
GIOVA.A88
  • 189
  • 5

Trigger spatial join on isert and update

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value from schemaB.table2 on st_contains(schemaB.table2.geom,schemaA.table1.geom)

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?

Best