X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7E8B3D1B97C for ; Fri, 5 Sep 2003 06:54:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 05593-06 for ; Fri, 5 Sep 2003 03:54:37 -0300 (ADT) Received: from mail.mera.ru (FireWall.mera.ru [195.98.50.58]) by svr1.postgresql.org (Postfix) with ESMTP id 5A1FCD1B8BF for ; Fri, 5 Sep 2003 03:54:34 -0300 (ADT) Received: from drweb by mail.mera.ru with drweb-scanned (Exim 4.20) id 19vAUL-000PHF-8N; Fri, 05 Sep 2003 10:54:33 +0400 Received: from [192.168.12.128] (helo=ulyanov) by mail.mera.ru with smtp (Exim 4.20) id 19vAUK-000PH3-Pr; Fri, 05 Sep 2003 10:54:32 +0400 X-AntiVirus: Checked by Dr.Web (http://www.drweb.net) Message-ID: <01e401c3737a$f7dff5c0$800ca8c0@meraqms.ru> From: "Yaroslav Ulyanov" To: "George Weaver" , References: <010401c372b8$af853f00$800ca8c0@meraqms.ru> <013a01c37326$04174050$740da18e@cleartag> Subject: Re: Help me Date: Fri, 5 Sep 2003 10:57:26 +0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01E1_01C3739C.7E3A2CA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_50_60, RCVD_IN_OSIRUSOFT_COM, REFERENCES X-Spam-Level: * X-Archive-Number: 200309/27 X-Sequence-Number: 15005 This is a multi-part message in MIME format. ------=_NextPart_000_01E1_01C3739C.7E3A2CA0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Very thanks, George! ----- Original Message -----=20 From: George Weaver=20 To: Yaroslav Ulyanov ; pgsql-sql@postgresql.org=20 Sent: Friday, September 05, 2003 12:48 AM Subject: Re: [SQL] Help me Hi Yaroslav, You must set the language as: LANGUAGE 'plpgsql'; Regards, George ----- Original Message -----=20 From: Yaroslav Ulyanov=20 To: pgsql-sql@postgresql.org=20 Sent: Thursday, September 04, 2003 2:46 AM Subject: [SQL] Help me Hello I cannot write new function with local variables (see image in attachme= nt). That I do wrong? Best regards, Yaroslav Ulyanov yulyanov@mera.ru=20 ---------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ------=_NextPart_000_01E1_01C3739C.7E3A2CA0 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable

Very thanks, George!

----- Original Message -----
Fro= m:=20 George Weave= r=20
To: Yaroslav Ulyanov ; pgsql-sql@postgresql.org
Sent: Friday, September 05, 2003 1= 2:48=20 AM

Subject: Re: [SQL] Help me

Hi Yaroslav,

You must set the language as:

LANGUAGE 'plpgsql';

Regards,

George

----- Original Message -----
F= rom:=20 Yaroslav= =20 Ulyanov

To: pgsql-sql@postgresql.org <= /DIV>
Sent: Thursday, September 04, 20= 03 2:46=20 AM

Subject: [SQL] Help me

Hello

I cannot write new function with local= =20 variables (see image in attachment).

That I do wrong?

Best regards,
Yaroslav Ulyanov
<= A=20 href=3D"mailto:yulyanov@mera.ru">yulyanov@mera.ru

---------------------------(end of=20 broadcast)---------------------------
TIP 5: Have you checked our=20 extensive=20 FAQ?

= ; =20 http://www.postgr= esql.org/docs/faqs/FAQ.html

------=_NextPart_000_01E1_01C3739C.7E3A2CA0--