Re: help with sintaxis of quotes on function

On Wed, 7 Nov 2001, Ernesto Freyre wrote:

> Dear Sirs:
>
> Please I am attempting implement a function that update a column to current time + X seconds
>
> So the query involved looks like:
>
> update mytable set mytime=now+'X seconds';
>
> Here X is a integer value,
>
> Now I need implement this on my function, But I have problems at
> implement this at quotes, e.g. my function could looks like:
>
> CREATE FUNCTION addtime(integer) RETURNS INTEGER AS '
> DECLARE
> additional ALIAS FOR $1;
> BEGIN
> update mytable set mytime=now()+''additional seconds'';
> END;
> '
> return 1;
> LANGUAGE 'plpgsql';

This may work as the update:

update mytable set mytime=now()+CAST((additional || '' seconds'')
AS INTERVAL);