Hi Joe;
thank a lot for the guide about the garbage character. I had copied and
pasted it before, but now I've retyped it by hand and it works perfectly.
This function will be very very useful for me.
Best regards,
Javier
-----------------------------------------------------------------
El Mar 09 Mar 2004 18:37, Joe Conway escribió:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
