Re: [postgis-users] Loop or Cursor

2009-07-23 Thread Bob Pawley
Original Message - From: Paragon Corporation To: 'PostGIS Users Discussion' Sent: Tuesday, July 21, 2009 11:38 PM Subject: Re: [postgis-users] Loop or Cursor Bob, For this kind of thing -- we usually use a database trigger on the AFTER INSERT row event of the table in questio

Re: [postgis-users] Loop or Cursor

2009-07-21 Thread Paragon Corporation
l Message - From: Paragon Corporation <mailto:l...@pcorp.us> To: 'PostGIS Users <mailto:postgis-users@postgis.refractions.net> Discussion' Sent: Monday, July 20, 2009 7:45 PM Subject: Re: [postgis-users] Loop or Cursor What kind of operation? Even an update statement mig

Re: [postgis-users] Loop or Cursor

2009-07-21 Thread Bob Pawley
on Corporation To: 'PostGIS Users Discussion' Sent: Monday, July 20, 2009 7:45 PM Subject: Re: [postgis-users] Loop or Cursor What kind of operation? Even an update statement might suffice. There are many ways to cleverly control the flow of an update that do not necessitate d

Re: [postgis-users] Loop or Cursor

2009-07-20 Thread Paragon Corporation
What kind of operation? Even an update statement might suffice. There are many ways to cleverly control the flow of an update that do not necessitate doing a loop or cursor. Also keep in mind even within a function used in a SELECT statement of a query, PostgreSQL allows you to run updates and