plpgsql

Welcome to the 'plpgsql' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'plpgsql'.

Latest blogosphere posts tagged “plpgsql”

• pgTAP Best Practices Slides Available

  
  Just a Theory — Authority: 118
  PgTAP Best Practices View more presentations from David Wheeler . Last month I gave two presentations at the PostgreSQL Conference West . The first was a variation on Unit Test Your Database! , which Ive now given about six times (and will at least two more times, including tomorrow night for Portland PLUG ...
  1 week ago

• Waiting for 8.5 – DO

  
  select * from depesz; — Authority: 111
  On 22nd of September, Tom Lane committed a patch by Petr Jelinek:Log Message:-----------Implement the DO statement to support execution of PL code without havingto create a function for it. Procedural languages now have an additional entry point, namely a functionto execute an inline code block. This seemed a better ...
  2 weeks ago

• Calculating backlog of events to handle

  
  select * from depesz; — Authority: 111
  Yesterday on my favorite IRC channel fooqux asked interesting question. I took some more questions, and here is problem description:We have a system which, every 5 minutes, takes a number of tasks to be done. Tasks are uniform. Within 5 minutes we can handle at most 100 tasks. Given the history of number of tasks [...]
  2 weeks ago

• Waiting for 8.5 – MOVE {FORWARD,BACKWARD} X

  
  select * from depesz; — Authority: 111
  On 29th of September (I know, there is a backlog – I’ll work on it, I promise), Tom Lane committed another patch from Pavel Stehule:Allow MOVE FORWARD n, MOVE BACKWARD n, MOVE FORWARD ALL, MOVE BACKWARD ALLin plpgsql. Clean up a couple of corner cases in the MOVE/FETCH syntax. Pavel StehuleDescription is pretty ...
  4 weeks ago

Comments about plpgsql