javier garcia - CEBAS wrote:
> I've loaded it in the server but when I try to use it exactly as in the
> example Joe gives or in other way I obtain the answer:
> ---------------------
> murciadb=# SELECT ts FROM generate_ts('14/10/1999 01:02:45 UTC','26/12/2000
> 06:01:00 UTC','3 hours') AS t(ts);
> ERROR: syntax error at or near "alias" at character 22
> CONTEXT: invalid type name "v_start alias for $1"
> compile of PL/pgSQL function "generate_ts" near line 2
I can reproduce that message if I add a garbage character to the
beginning of the noted line. Did you retype the function or
cut-and-paste? Please run:
select prosrc from pg_proc where proname = 'generate_ts';
and post the result here.
Joe
