Re: creating sequential timestamp

From: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: creating sequential timestamp
Date: 2004-03-11 17:10:42
Message-ID: 200403111710.i2BHAFC06913@natura.cebas.csic.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paolo Tavalazzi 2004-03-11 17:25:48 Re: postgres FROM clause problem
Previous Message Tom Lane 2004-03-11 17:03:30 Re: postgres FROM clause problem