DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=FEB6rTr/5oAb2qadS67fGw2qYVWYuL611h/DNDQSPlNOU4KYSO0onb0QL6ETzRx7GsuvrGAZw9Cn6u2ZQ+w46USSkI86r/5OVmzMOiuiGzpNdVo6FH1Z6fLXciJQXLlLt+pTEVQMNnX3Gd76DcsFICU8aSlx1WMA0zvDlnY5kxI=
Message-ID: <c2d9e70e05072212331a7aa6bd@mail.gmail.com>
Date: Fri, 22 Jul 2005 14:33:11 -0500
From: Jaime Casanova <systemguards@gmail.com>
Reply-To: Jaime Casanova <systemguards@gmail.com>
To: Bricklen Anderson <BAnderson@presinet.com>
Subject: Re: Tigger
Cc: David Hofmann <mor4321@hotmail.com>, pgsql-sql@postgresql.org
In-Reply-To: <42E14655.4090106@PresiNET.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <BAY105-F13ED683B496DCE39673E6FBBC90@phx.gbl>
	<42E14655.4090106@PresiNET.com>

 David Hofmann wrote:
> > I've look throught the docs and from what I can see the bellow code
> > should work, however I keep getting the error:
> >
> > ERROR:  parser: parse error at or near "$" at character 53
> >
> > CREATE FUNCTION session_update() RETURNS trigger AS $session_update$
> > BEGIN
> >     -- Check date exists
> >     IF NEW.stamp_lastupdate IS NULL THEN
> >         NEW.stamp_lastupdate :=3D 'now';
> >     END IF;
> >     RETURN NEW;
> > END;
> >
> > $session_update$ LANGUAGE plpgsql;
> >
> > CREATE TRIGGER session_update BEFORE INSERT OR UPDATE ON sessions FOR
> > EACH ROW EXECUTE PROCEDURE session_update();
> >
> >
> > Any help or suggestions of websites I should read would be appercated.
> >
> > David
>=20
> Which version of postgresql are you using? I don't believe that the "$" q=
uoting
> was available in older versions than 8 (or late 7?).
>=20

the $ quoting is available since 8.

This seems bad to me also:
> > CREATE FUNCTION session_update() RETURNS trigger AS $session_update$
> > [..function body..]
> > $session_update$ LANGUAGE plpgsql;

I think it should be:
CREATE FUNCTION session_update() RETURNS trigger AS $$
[..function body..]
$$ LANGUAGE plpgsql;


--=20
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)