I was looking for a solution to display source code in way that was readable when posting on my blog. After several failed attempts to format some PHP and SQL code with the PRE tag and CSS styles, I found this nice tool provided by google witch helps you to format/highlight source code on your web pages.

Google SyntaxHighlighter

-- Function: new_expiredate()

-- DROP FUNCTION new_expiredate();

CREATE OR REPLACE FUNCTION new_expiredate()
  RETURNS timestamp without time zone AS
$BODY$
	select (date_trunc('month',now()) + interval '7 months')::timestamp without time zone;
$BODY$
  LANGUAGE 'sql' VOLATILE
  COST 100;
ALTER FUNCTION new_expiredate() OWNER TO postgres;