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”

• Waiting for 8.5 – Named function arguments

  
  select * from depesz; — Authority: 107
  Pavel Stehule – hero for everybody writing stored procedures, wrote, and later Tom Lane committed patch which adds named arguments for functions:Log Message:-----------Support use of function argument names to identify which actual argumentsmatch which function parameters. The syntax uses AS, for ...
  2 weeks ago

• pgTAP Best Practices Slides Available

  
  Just a Theory — Authority: 110
  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 ...
  4 weeks ago

• Waiting for 8.5 – DO

  
  select * from depesz; — Authority: 107
  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 ...
  4 weeks ago

• Calculating backlog of events to handle

  
  select * from depesz; — Authority: 107
  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 [...]
  5 weeks ago

Comments about plpgsql