Re: Declaring timestamp variables in function

From: Laurent <lduperval(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Declaring timestamp variables in function
Date: 2011-03-11 02:22:56
Message-ID: 092c599f-62ef-4c00-b4b3-a62b280ef1e2@p11g2000vbq.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mar 10, 6:27 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> Laurent <lduper(dot)(dot)(dot)(at)gmail(dot)com> writes:
> > -- here I update my date
> > END;
> > $$ LANGUAGE SQL;
> The problem's at the other end of that command :-(.  You need to
> say language plpgsql, not language sql.
>

Yep, that was it. All is well now, thanks.

L

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2011-03-11 03:23:21 Re: psql in postgres 9.0.3 not accepting password
Previous Message Tom Lane 2011-03-10 23:27:26 Re: Declaring timestamp variables in function