[SQL] Re: Retrieve the column values of a record without knowing the names

Thanks Dmitry Grishin. The only problem is that my DBA didn't permit install this command... :( But, I quit this problem... Thanks by attention... -- View this message in context: http://postgresql.1045698.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387932p3

[SQL] Re: Retrieve the column values of a record without knowing the names

Wow, I don't know if I exposed the problem in the right way, but I'm not achieving the solution with information_schema... Let me show the function: CREATE OR REPLACE FUNCTION fc_teste_tce2(codigo_aluno integer) RETURNS character varying AS $BODY$ DECLARE reg record; reg2 record; msg cha

[SQL] Re: Retrieve the column values of a record without knowing the names

Wow, how I didn't think about this solution? Thanks a lot! So easy... -- View this message in context: http://postgresql.1045698.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387932p3390950.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com

[SQL] Re: Retrieve the column values of a record without knowing the names

Very interesting... But with information_schema.columns is easier... Thanks anyway... -- View this message in context: http://postgresql.1045698.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387932p3390948.html Sent from the PostgreSQL - sql mailing list arch