Every now and then I need a function that returns nothing. As you perhaps know, even defining function as "RETURNS VOID" doesn't fully solve the problem:
April 27th, 2011 by depesz | Tags: combinations, cte, postgresql, recursive, stackoverflow, with recursive | 11 comments »
Today, on Stack Overflow there was interesting question. Generally, given table that looks like this: room | people | price | hotel 1 | 1 | 200 | ...
August 20th, 2009 by depesz | Tags: configuration, plpgsql, postgresql, sessions, sql, stackoverflow, variables | 6 comments »
This post has been updated with new code that uses temporary table - the code is at the end of post! There was this question on Stack Overflow. For future reference: guy asked how to do session variables - i.e. something he ...
