X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 66183DADF9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 26 Oct 2005 09:53:34 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 83155-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 26 Oct 2005 12:53:30 +0000 (GMT)
Received: from wimpy.net.nih.gov (mailfwd.nih.gov [128.231.88.106])
	by svr1.postgresql.org (Postfix) with ESMTP id CC9ECDADEA
	for <pgsql-sql@postgresql.org>; Wed, 26 Oct 2005 09:53:32 -0300 (ADT)
Received: from wimpy.net.nih.gov (localhost [127.0.0.1])
	by wimpy.net.nih.gov (8.12.11/8.11.7) with ESMTP id j9QCrZ8v015533
	for <pgsql-sql@postgresql.org>; Wed, 26 Oct 2005 08:53:36 -0400 (EDT)
Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14])
	by wimpy.net.nih.gov (8.12.11/8.11.7) with ESMTP id j9QCrYhE015527;
	Wed, 26 Oct 2005 08:53:34 -0400 (EDT)
User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Wed, 26 Oct 2005 08:54:51 -0400
Subject: Re: RETURNS SETOF primitive returns results in parentheses
From: Sean Davis <sdavis2@mail.nih.gov>
To: <mario.splivalo@mobart.hr>, <pgsql-sql@postgresql.org>
Message-ID: <BF84F4DB.11C9D%sdavis2@mail.nih.gov>
In-Reply-To: <1130330322.7400.45.camel@ekim>
Mime-version: 1.0
Content-type: text/plain; charset="EUC-KR"
Content-transfer-encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.013 required=5 tests=[AWL=0.013]
X-Spam-Level: 
X-Archive-Number: 200510/322
X-Sequence-Number: 23175

On 10/26/05 8:38 AM, "Mario Splivalo" <mario.splivalo@mobart.hr> wrote:

> Consider this function:
>=20
> CREATE OR REPLACE FUNCTION php_get_subfield_data_repeating(int4,
> "varchar")
> RETURNS SETOF "varchar" AS
> $BODY$
> DECLARE
> aRecordID ALIAS FOR $1;
> aSubFieldId ALIAS FOR $2;
>=20
> returnValue record;
> subFieldNumber char(3);
> subFieldLetter char(1);
>=20
> BEGIN
> subFieldNumber =3D substr(aSubFieldId, 1, 3);
> subFieldLetter =3D substr(aSubFieldId, 4);
>=20
> FOR returnValue IN SELECT "subfieldValue"::varchar
> FROM "records_sub"
> WHERE "fieldTag" =3D subFieldNumber AND "subfieldTag" =3D subFieldLetter
> AND "recordId" =3D aRecordId
> LOOP
> RETURN NEXT returnValue;
> END LOOP;
>=20
> RETURN;
> END
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>=20
>=20
>=20
> Now, when I do this:
>=20
> biblio3=3D# select * from php_get_subfield_data_repeating(1,'606a');
> php_get_subfield_data_repeating1
> ----------------------------------
> (An=A9=A2eli)
> (ofsajd)
> (2 rows)

Does:

select * from php_get_subfield_data_repeating(1,'606a') as s(a)

do what you want (single column)?