CREATE OR REPLACE FUNCTION dayOfWeek (date Date) RETURNS Character Varying(15) AS $$
DECLARE
	DAY_OF_WEEK_CONST Character Varying(15) := 'dow';

	dayOfWeek Integer := 0;
	dayName Character Varying(15) := 'Test';
BEGIN
	
	dayOfWeek := date_part(DAY_OF_WEEK_CONST, Date);

	IF dayOfWeek = 0 THEN
		dayName := 'Sunday';
	ELSEIF dayOfWeek = 1 THEN
		dayName := 'Monday';
	ELSEIF dayOfWeek = 2 THEN
		dayName := 'Tuesday';
	ELSEIF dayOfWeek = 3 THEN
		dayName := 'Wednesday';
	ELSEIF dayOfWeek = 4 THEN
		dayName := 'Thursday';
	ELSEIF dayOfWeek = 5 THEN
		dayName := 'Friday';
	ELSEIF dayOfWeek = 6 THEN
		dayName := 'Saturday';
	END IF;
	RETURN dayName;
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION year (date1 Date) RETURNS integer AS $$
DECLARE
	YEAR_CONST Character Varying(15) := 'year';

	yearPart Integer := 0;
	yearPartInDoublePrecision Double Precision := 0;
BEGIN
	
	yearPartInDoublePrecision := date_part(YEAR_CONST, date1);

	yearPart := CAST(yearPartInDoublePrecision as Integer);
	RETURN yearPart;
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION datediff (diffType Character Varying(15), date1 Date, date2 Date) RETURNS integer AS $$
DECLARE
	YEAR_CONST Character Varying(15) := 'year';
	MONTH_CONST Character Varying(15) := 'month';
	DAY_CONST Character Varying(15) := 'day';

	diffInInterval Interval;
	diffInDoublePrecision Double Precision := 0;
	diffInInteger Integer := 0;
	dateTemp Date;
BEGIN
	
	diffInInterval := age(date2, date1);

	IF lower($1) = lower(YEAR_CONST) THEN
		diffInDoublePrecision := date_part('Year', diffInInterval);
	ELSEIF lower($1) = lower(MONTH_CONST) THEN
		diffInDoublePrecision := (date_part('Year', diffInInterval) * 12) + date_part('Month', diffInInterval);
	ELSEIF lower($1) = lower(DAY_CONST) THEN
		diffInDoublePrecision := endDate - startDate;
	END IF;

	diffInInteger := CAST(diffInDoublePrecision as Integer);
	RETURN diffInInteger;
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION LastDateOfMonth(date) RETURNS date AS '
SELECT CAST(date_trunc(''month'', $1) + interval ''1 month''
- interval ''1 day'' as date);
' LANGUAGE sql;

CREATE OR REPLACE FUNCTION dateadd(diffType Character Varying(15), incrementValue int, inputDate timestamp) RETURNS timestamp AS $$
DECLARE
   YEAR_CONST Char(15) := 'year';
   MONTH_CONST Char(15) := 'month';
   DAY_CONST Char(15) := 'day';

   dateTemp Date;
   intervalValue varchar (100);
BEGIN
      IF lower($1) = lower(YEAR_CONST) THEN
       dateTemp := inputDate +  interval '$2 year';
   ELSEIF lower($1) = lower(MONTH_CONST) THEN
       dateTemp := inputDate +  interval  '$2 months';
   ELSEIF lower($1) = lower(DAY_CONST) THEN
       dateTemp := inputDate +  interval  '$2 day';
   END IF;

   RETURN dateTemp;
END;
$$ LANGUAGE plpgsql;

SELECT Name, Value FROM Month;
select Name, REPEAT("#", Value/20.0+1) Graph FROM Month;

class PromotionManager {
	static $sharedInstance;
	
	static function sharedManager () {
		if(!self::$sharedInstance) {
			self::$sharedInstance = new self();
		}
		
		return self::$sharedInstance;
	}
	
	function __construct() {
		
	}
}

$('#input_text').keyup(function(e) {
	//alert(e.keyCode);
	if(e.keyCode == 13) {
		alert('Enter key was pressed.');
	}
});

<span class="adr">
	<span class="street-address">6255 McLeod Lane N.E.</span><br />
	<span class="locality">Kiezer<span>, <span class="region">Oregon</span> <span class="postal-code">97303</span><br />
	<span class="country-name">United States</span><br />
</span>

<div id="SiteHeader" class="global">
    <h1 id="SiteTitle" class="global header fn n">
        <span class="given-name">Lee</span>
        <span class="additional-name">R</span>
        <span class="family-name">Johnson</span>
    </h1>
    <h2 id="PageTitle" class="local header">Design Ideas for Web Development</h2>
</div>