Re: [GENERAL] User defined function

> I need to write a function to return the first of december of the year
> previous to the current year. Part of my problem is I'm not sure how
> to escape quotes in function definitions. I am looking at something
> along the lines of
>
> CREATE FUNCTION startofregyear(date) RETURNS date AS '
> SELECT text_datetime('01/12/' �� float8_text(datepart('year',$1)-1))
> AS answer;
> ' LANGUAGE 'SQL';
>
> but clearly this won't work because of the large number of single
> quotes. I've tried escaping the quotes in the SELECT line with
> backslashes, but that doesn't seem to do it.
>
> Can anyone tell me if this function should work, once I sort out the
> escaping?
>
   try using double quotas...

  CREATE FUNCTION startofregyear(date) RETURNS date AS '
  SELECT text_datetime(''01/12/''  float8_text(datepart(''year'',$1)-1))
  AS answer;
  ' LANGUAGE 'SQL';

  It should work...

  --Greg--