Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
plv8 Archives - PostgreSQL Candies

JavaScript in PostgreSQL pl/v8 – tutorial 4 – trigger functions

To write a trigger function in plv8 is much more convenient than in PL/pgSQL. Mainly because objects OLD and NEW are real objects containing also column names. And therefore you do not need to care about actual table structure. To send them to other variable you...

Playing with JSON data in PostgreSQL

still in TODO Overview: JSON is right now very “fashionable” data format. And as they say “everyone uses it” or “it powers the whole web” etc. I remember times when XML format was “the coolest of all” and now it is...