Creating a function with single quotes - Mailing list pgsql-sql

From Shawn Tayler
Subject Creating a function with single quotes
Date
Msg-id 1235058071.29030.82.camel@shop.telecom.co.washoe.nv.us
Whole thread Raw
Responses Re: Creating a function with single quotes  (Agustin Bialet <abialet@gmail.com>)
Re: Creating a function with single quotes  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Hello,

This has me befuddled.  I am trying create a simple experiment, rather
new to SQL and I am running into an issue with single quotes.  All I can
find on creating a function states the procedure should be contained
within single quotes.  My problem comes when I want to use a textual
representation of an interval.

create function csd_interval(integer) returns interval as 
'BEGIN
RETURN $1 * interval '1 msec'
END;'
LANGUAGE 'plpgsql';

it always fails at the '1 msec' point.

Suggestions?
-- 
Sincerely,

Shawn Tayler
Radio Network Administrator
Washoe County Regional Communications System
Telecommunications Division
Technology Services Department
County of Washoe
State of Nevada
Ofc  (775)858-5952
Cell (775)771-4241
FAX  (775)858-5960



pgsql-sql by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Funtion to clean up strings?
Next
From: Agustin Bialet
Date:
Subject: Re: Creating a function with single quotes