On 2009-02-19, Shawn Tayler stay...@washoecounty.us 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
Hello Jasen and the List,
I tried the $$ quote suggestion:
create function f_csd_interval(integer) returns interval as
$$
BEGIN
RETURN $1 * interval '1 msec'
END;
$$
LANGUAGE 'plpgsql';
Here is what I got:
edacs=# \i 'f_csd_interval.sql'
psql:f_csd_interval.sql:7: ERROR: syntax error at or
On Friday 20. February 2009, Shawn Tayler wrote:
Hello Jasen and the List,
I tried the $$ quote suggestion:
create function f_csd_interval(integer) returns interval as
$$
BEGIN
RETURN $1 * interval '1 msec'
END;
$$
LANGUAGE 'plpgsql';
Here is what I got:
edacs=# \i 'f_csd_interval.sql'
Memo to self:
Remember hit reply all.
-- Forwarded Message --
Subject: Re: [SQL] Creating a function with single quotes
Date: Friday 20 February 2009
From: Adrian Klaver akla...@comcast.net
To: Leif B. Kristensen l...@solumslekt.org
On Friday 20 February 2009 6:13:03 am you
On Friday 20. February 2009, Adrian Klaver wrote:
Actually you need both semicolons. One after the RETURN statement and
one after the END statement
See below for full details:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-structure.html
I see the documentation, but empirically you
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
