plPHP beta released

by: Robby Russell

August 18, 2003

Command Prompt, Inc. (authors of Practical PostgreSQL from O'ReillY) are releasing their plPHP ( http://www.commandprompt.com/entry.lxp?lxpe=260 )to the open source community under the PHP License. Now you can create custom postgreSQL function using your favority scripting language (php) and utilize them in the database.

Example:
We will replace each line break in a text field with a html break tag (followed by a line break).


CREATE OR REPLACE FUNCTION line_breaks(text) RETURNS text AS '
  $txt = str_replace("\n","<br&gt;\n", $arg0);
  if ($txt) {
    return $txt;
  }
' LANGUAGE 'plphp';




Then you can call your SELECT like so:



dbname=# SELECT id, line_breaks(body) FROM table1 ;
 id |        line_breaks
----+-----------------------
  1 | Lots of text

wjpoefjeowpqjf

body text r09u3 



 234jr23032ur03u29r0u

p2jend of text
(1 row)

Comment and Contribute

0 Comments (click to add your comment)

Your comment has been submitted and is pending approval.

Author:

Robby Russell

Comment:

Name/nickname:
Email:

Comment:

(Maximum characters: 1200). You have characters left.