Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 6E029633C51 for ; Mon, 24 May 2010 19:14:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 77249-04 for ; Mon, 24 May 2010 22:14:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 8FBEA633A70 for ; Mon, 24 May 2010 19:14:49 -0300 (ADT) Received: by gyg13 with SMTP id 13so1702913gyg.19 for ; Mon, 24 May 2010 15:14:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:cc :subject:references:mime-version:content-type:content-disposition :in-reply-to:user-agent; bh=0bqba77c5JrLtc0fGcdsY1dKPeN0AKsUN+kb2DB14H4=; b=Przf8fir0wICX6WZKqf5ClndS8B0cAWPyaeN/ZFQe+/yRkFbILUJyuT4ecdWWQ6w/2 kwTtc+nwqiaLfnJF1OI72jXPmZOjj1gMzjOoayHgxhZZ1gmw+k1OCYMpFqMPrJGi8VDe qn26kmfjtZ9hsCNrylrik98OdDrwFx1SgLGaI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:cc:subject:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; b=J6yEmAOtnYY5SNR80wf7MM0p3SkNA9gB5yOujeKzmCFptViZi0lwyOAue5qdjpuFrJ 6fV+Kl7f1hid0TTrGlzdFjDICS7W29TKNukU+WpiDBZM3bdRGfeadIGEXlu2rJc5H95V Ewka2x8zbvE9g5Of7c/o8FrnMnLENDq4D6xI0= Received: by 10.101.6.1 with SMTP id j1mr7223708ani.200.1274739288314; Mon, 24 May 2010 15:14:48 -0700 (PDT) Received: from eddie (c-67-182-224-31.hsd1.ut.comcast.net [67.182.224.31]) by mx.google.com with ESMTPS id f7sm18969308anb.17.2010.05.24.15.14.46 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 24 May 2010 15:14:47 -0700 (PDT) Message-ID: <4bfafa57.0752640a.0b22.ffff88ac@mx.google.com> Date: Mon, 24 May 2010 16:14:45 -0600 From: Joshua Tolley To: David Harel Cc: postgres sql Subject: Re: User function that returns a set of rows. References: <4BFAC67F.8050504@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="kadn00tgSopKmJ1H" Content-Disposition: inline In-Reply-To: <4BFAC67F.8050504@gmail.com> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201005/111 X-Sequence-Number: 34159 --kadn00tgSopKmJ1H Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, May 24, 2010 at 09:33:35PM +0300, David Harel wrote: > When I tried it from the shell I got a nasty error message about that = I am > not in an environment to receive a set ??? (can't see it now. Office > restrictions). >=20 > Any idea? Your query should say something like "SELECT * FROM select_business_types()= ". You'll get that error if you instead say "SELECT select_business_types()". -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com --kadn00tgSopKmJ1H Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkv6+lUACgkQRiRfCGf1UMN1AACdGEleVFUtUTenlY1ONaVeTyeV +1AAmwQQInkMPwyhD9L7UMwbBEnS9A8D =ixQj -----END PGP SIGNATURE----- --kadn00tgSopKmJ1H--