Creating a function with single quotes
От | Shawn Tayler |
---|---|
Тема | Creating a function with single quotes |
Дата | |
Msg-id | 1235058071.29030.82.camel@shop.telecom.co.washoe.nv.us обсуждение исходный текст |
Ответы |
Re: Creating a function with single quotes
Re: Creating a function with single quotes |
Список | 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 по дате отправления: