From: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
---|---|
To: | "Lukasz Feldman" <lukasz(at)atm(dot)com(dot)pl> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: what's going on... |
Date: | 2001-12-05 16:04:10 |
Message-ID: | 87vgflbqmd.fsf@npa01zz001.simplot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
You need to escape single quotes "'" in plpgsql functions. The
correct function should look like this:
CREATE FUNCTION analizuj_pomiary() RETURNS bool AS '
DECLARE pomiary RECORD;
BEGIN
FOR pomiary IN SELECT * FROM brewan_pomiar LOOP
IF substr(pomiary.datetime,1,10)=to_char(now(),''mm/dd/yyyy'')
THEN ^ ^
INSERT INTO TESTOWA | |
VALUES ( | |
analizuj_flow( | |
pomiary.ipRouter, | |
pomiary.source_ip, +-----+-----+
pomiary.dest_ip, |
pomiary.bytes, |
pomiary.datetime) |
); Look at US!!
END IF;
END LOOP;
RETURN true;
END; ' LANGUAGE 'plpgsql';
Jason
"Lukasz Feldman" <lukasz(at)atm(dot)com(dot)pl> writes:
> Hello!
>
> I was trying to create a function:
>
> CREATE FUNCTION analizuj_pomiary() RETURNS bool AS '
> DECLARE pomiary RECORD;
> BEGIN
> FOR pomiary IN SELECT * FROM brewan_pomiar LOOP
>
> IF substr(pomiary.datetime,1,10)=to_char(now(),'mm/dd/yyyy')
> THEN
> INSERT INTO TESTOWA
> VALUES (
> analizuj_flow(
> pomiary.ipRouter,
> pomiary.source_ip,
> pomiary.dest_ip,
> pomiary.bytes,
> pomiary.datetime)
> );
> END IF;
>
> END LOOP;
> RETURN true;
> END; ' LANGUAGE 'plpgsql';
>
> ... and I received an error:
>
> ERROR: parser: parse error at or near "mm"
>
> What's going on? What does it mean?
>
> -----
> Łukasz Feldman, Konsultant
> Zespol Konsultantow ds. Systemów Zarzadzania Sieciami i Systemami
> Telekomunikacyjnymi;
> ATM S.A., ul. Grochowska 21a, 04-186 Warszawa, POLAND
> tel (+48 22) 5156332, fax (+48 22) 5156146, mobile (+48) 607 167 634 ,
> http://www.atm.com.pl
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Hauser | 2001-12-05 23:33:26 | Storing number '001' ? |
Previous Message | Lukasz Feldman | 2001-12-05 13:48:15 | what's going on... |