Questions tagged [plpgsql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
39 views

Passing arguments to PostgreSQL plpgsql

I have a PostGIS query which works fine on its own: select distinct gis.filelinks_qtrqtrs_view.entity, gis.filelinks_qtrqtrs_view.type, gis.filelinks_qtrqtrs_view.url from public....
1
vote
0answers
24 views

PostGIS - suppress errors

Is there any way in SQL to supress errors in PostGIS functions, for instance if some of your geometries are invalid but you want to report a null value for the output or something? To give an example,...
3
votes
1answer
126 views

PostGIS trigger does not work as expected while checking intersections

I'm trying to write a trigger that should prevent saving lines which do not end at building boundaries. ( A PostGIS-Solution for something like the topology-rule "Must be covered by boundary of" in ...
0
votes
1answer
32 views

Trigger to SELECT schema rows based on WHERE condition

I am learning about triggers. Generally it seems triggers are employed on the backend to perform some action on a schema. I was interested if it was possible for a trigger to return data on a SELECT ...
1
vote
0answers
52 views

Trigger history_ How can I define the last updated column?

I am trying to implement a trigger function in PostgreSQL. I've written this trigger history function: CREATE OR REPLACE FUNCTION history_update() RETURNS trigger AS $$ BEGIN INSERT INTO ...
1
vote
0answers
44 views

QGIS plpgsql RAISE MESSAGEs do not appear in QGIS Log Messages Panel | PostGIS Tab

I refer to this post Show "Raise Notice" and "Raise Warning" in QGIS and to the herein referred issue https://issues.qgis.org/issues/12184#change-59414. Using QGIS 2.18.18 LTR I ...