On Feb 19, 2009, at 1:41 PM, Shawn Tayler wrote:
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.
Try using:
create function csd_interval(integer) returns interval as $$
BEGIN
RETURN $1 * interval '1 msec'
END;
$$ LANGUAGE 'plpgsql';
For more info refer to section 4.1.2.2. Dollar-Quoted String Constants
in the manual.
Agustin
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
