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

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