Re: Creating a function with single quotes

Поиск
Список
Период
Сортировка
От Shawn Tayler
Тема Re: Creating a function with single quotes
Дата
Msg-id 1235139753.13564.19.camel@shop.telecom.co.washoe.nv.us
обсуждение исходный текст
Ответ на Creating a function with single quotes  (Shawn Tayler <stayler@washoecounty.us>)
Список pgsql-sql
Hi Leif!

Thank you to you and the group.  Worked like a charm.  The SQL language
was the key....


Shawn


On Fri, 2009-02-20 at 15:12 +0100, Leif B. Kristensen wrote:
> You should place a semicolon at the end of the RETURN line, and
> remove 
> the one after END,
> 
> BTW, simple functions as this are better written in the SQL language.
> I 
> can't speak for the validity of the code itself, but you can rewrite
> it 
> as
> 
> create function f_csd_interval(integer) returns interval as $$
> SELECT $1 * interval '1 msec'
> $$ LANGUAGE SQL;
-- 
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 по дате отправления:

Предыдущее
От: "Leif B. Kristensen"
Дата:
Сообщение: Re: Creating a function with single quotes
Следующее
От: Adrian Klaver
Дата:
Сообщение: Fwd: Re: Creating a function with single quotes