March 10th, 2010 by depesz | Tags: dynamic, field, impossible, irc, plpgsql, postgresql, record, trigger, triggers | No comments »
Dynamic updates of fields in NEW in PL/pgSQL Today, on #postgresql on IRC, strk asked about updating fields in NEW record, in plpgsql, but where name of the field is in variable. After some time, he sent his question to hackers mailing ...
July 13th, 2009 by depesz | Tags: aggre, aggregate, dim, irc, plpgsql, postgresql, rhodiumtoad, sql | 1 comment »
Today, on irc (#postgresql on freenode.net) Dim mentioned about writing median calculation code. It got me thinking, and consequently writing my version of median calculation code.
December 1st, 2008 by depesz | Tags: domain, functions, irc, plpgsql, postgresql, report, sql | 4 comments »
Today, on #postgresql on IRC, guy (can't contact him now to get his permission to name him), said: I have a table called problematic_hostnames. It contains a list of banned hostnames in column "hostname" (varchar). I would like to display the ...
