Received: from profit.net.ua (profit.net.ua [62.244.36.129]) by hub.org (8.10.1/8.10.1) with ESMTP id e63IGAS70951 for ; Mon, 3 Jul 2000 14:16:12 -0400 (EDT) Received: from x206 (dup-245.profit.net.ua [62.244.36.245]) by profit.net.ua (8.9.0/8.9.0) with SMTP id VAA10006 for ; Mon, 3 Jul 2000 21:15:57 +0300 (EEST) Message-ID: <004201bfe51a$91903240$0101010a@x206> From: "Andrey" To: Subject: maintain number in variable Date: Mon, 3 Jul 2000 21:14:42 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003F_01BFE533.B4BEF710" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2417.2000 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200007/19 This is a multi-part message in MIME format. ------=_NextPart_000_003F_01BFE533.B4BEF710 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Can I maintain id in variable such as: CREATE FUNCTION function1() RETURNS int4 AS ' $var =3D select nextval(''shipment_gen''); select $var; ' LANGUAGE 'sql' Andrey ------=_NextPart_000_003F_01BFE533.B4BEF710 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable
Can I maintain id in variable suc= h=20 as:

CREATE FUNCTION function1() RETURNS int4
AS '
   $var = =3D=20 select nextval(''shipment_gen'');
   select $var;
'
LANG= UAGE=20 'sql'

 

Andrey

------=_NextPart_000_003F_01BFE533.B4BEF710--