Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6DC35635D77 for ; Mon, 13 Jul 2009 00:33:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32095-07-4 for ; Mon, 13 Jul 2009 00:33:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.virtusa.com (smtp.virtusa.com [12.40.51.197]) by mail.postgresql.org (Postfix) with ESMTP id E0B396348B4 for ; Mon, 13 Jul 2009 00:33:43 -0300 (ADT) X-TM-IMSS-Message-ID: <1a8dd51e00000cbb@smtp.virtusa.com> Received: from ws-mailsvr.Virtusa.com (ws-mailsvr.virtusa.com [10.3.8.4]) by smtp.virtusa.com ([172.16.1.6]) with ESMTP (TREND IMSS SMTP Service 7.0) id 1a8dd51e00000cbb ; Sun, 12 Jul 2009 23:04:23 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CA0366.9F42E3B8" Subject: function returning a cursor and a scalar Date: Sun, 12 Jul 2009 23:07:15 -0400 Message-ID: <75F63F40B35C3144854E90019EB086770DDC0229@ws-mailsvr.Virtusa.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: function returning a cursor and a scalar Thread-Index: AcoDZwY7Lxzj7oRDS8imndNpjXty8Q== From: "Surajit Bhattacharjee" To: X-TM-AS-Product-Ver: IMSS-7.0.0.6298-5.6.0.1016-16760.004 X-TM-AS-Result: No--7.820-5.0-31-1 X-imss-scan-details: No--7.820-5.0-31-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200907/61 X-Sequence-Number: 32802 This is a multi-part message in MIME format. ------_=_NextPart_001_01CA0366.9F42E3B8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I=20am=20new=20to=20Postgresql=20and=20am=20trying=20to=20write=20a=20fun= ction=20which=20will=20do=20a search=20and=20return=20the=20first=20page=20of=20results=20along=20with= =20the=20total=20number of=20matches.=20How=20can=20I=20make=20my=20function=20return=20a=20curso= r=20AND=20a=20scalar=20- can=20I=20do=20the=20scalar=20as=20an=20OUT=20param=20and=20then=20make= =20the=20function explicitly=20RETURN=20a=20refcursor? =20 Surajit -------------------------------------------------------------------------= -------------------- This=20message,=20including=20any=20attachments,=20contains=20confidentia= l=20information=20intended=20for=20a=20specific=20individual=20and=20purp= ose,=20and=20is=20intended=20for=20the=20addressee=20only.=20Any=20unauth= orized=20disclosure,=20use,=20dissemination,=20copying,=20or=20distributi= on=20of=20this=20message=20or=20any=20of=20its=20attachments=20or=20the= =20information=20contained=20in=20this=20e-mail,=20or=20the=20taking=20of= =20any=20action=20based=20on=20it,=20is=20strictly=20prohibited.=20If=20y= ou=20are=20not=20the=20intended=20recipient,=20please=20notify=20the=20se= nder=20immediately=20by=20return=20e-mail=20and=20delete=20this=20message= . -------------------------------------------------------------------------= -------------------- ------_=_NextPart_001_01CA0366.9F42E3B8 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable I=20am=20new=20to=20Postgresql=20and=20am=20trying=20to=20write= =20a=20function=20which=20will=20do a=20search=20and=20return=20the=20first=20page=20of=20results=20along=20w= ith=20the=20total=20number=20of matches.=20How=20can=20I=20make=20my=20function=20return=20a=20cursor=20A= ND=20a=20scalar=20–=20can=20I do=20the=20scalar=20as=20an=20OUT=20param=20and=20then=20make=20the=20fun= ction=20explicitly=20RETURN=20a refcursor?

 

Surajit

---------=
-------------------------------------------------------------------------=
-----------

This=20message,=20including=20any=20attachments,=20contains=20confidentia=
l=20information=20intended=20for=20a=20specific=20individual=20and=20purp=
ose,=20and=20is=20intended=20for=20the=20addressee=20only.=20Any=20unauth=
orized=20disclosure,=20use,=20dissemination,=20copying,=20or=20distributi=
on=20of=20this=20message=20or=20any=20of=20its=20attachments=20or=20the=
=20information=20contained=20in=20this=20e-mail,=20or=20the=20taking=20of=
=20any=20action=20based=20on=20it,=20is=20strictly=20prohibited.=20If=20y=
ou=20are=20not=20the=20intended=20recipient,=20please=20notify=20the=20se=
nder=20immediately=20by=20return=20e-mail=20and=20delete=20this=20message=
.

-------------------------------------------------------------------------=
--------------------
------_=_NextPart_001_01CA0366.9F42E3B8--