From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: Retrieve the column values of a record without knowing the names
Date: Fri, 18 Feb 2011 11:10:00 +0200
User-Agent: KMail/1.9.7
References: <1297873099984-3387935.post@n5.nabble.com>
In-Reply-To: <1297873099984-3387935.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201102181110.00856.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Wednesday 16 February 2011 18:18:19 =CE=BF/=CE=B7 =
arthur_info =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
>=20
> Hello,
>=20
> I've got the following function and I want to access the fields values of=
 my
> record by index. The problem is that my select is retrieving each record
> line with all values and not each one of each row on my view... How can I
> solve this problem?=20
>=20

Well by your function, it seems that it does not do what you want.
You want to access the values of one row without knowing the names, but wha=
t you do
is create an array over the values of a *known* column.
Also where aluno =3D ''3043'' does not make any sense either.

Anyways, you might want to look at database metada as found in the informat=
ion_schema.
=46or a start you might want to look in information_schema.columns

> Thanks in advance.
>=20
>=20
> CREATE FUNCTION fc_teste_tce(aluno integer) RETURNS character varying AS
> $BODY$=20
> DECLARE
>   reg record;
> BEGIN
>   for reg in execute 'SELECT ARRAY (SELECT vw_teste_tce FROM
> estagio.vw_teste_tce where aluno =3D ''3043'' LIMIT 20) AS campos' loop
>     for j in 1..array_upper(reg.campos,1) loop
>       raise notice 'Field Value: %',reg.campos[j];
>     end loop;
>   end loop;
>   return 'ok';
> END; =20
> $BODY$
>=20
> LANGUAGE plpgsql VOLATILE;
>=20
>=20
> --=20
> View this message in context: http://postgresql.1045698.n5.nabble.com/Ret=
rieve-the-column-values-of-a-record-without-knowing-the-names-tp3387935p338=
7935.html
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>=20


=2D-=20
Achilleas Mantzios