Re: [GENERAL] Record Types Structure in PL/pgSQL

2007-06-08 Thread Merlin Moncure
On 6/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Diego Sanchez R." <[EMAIL PROTECTED]> writes: > Is there any way of determining the actual structure of a record variable? Not in plpgsql; even if the info were exposed, you couldn't do anything very useful because that language is strongly typed.

Re: [GENERAL] Record Types Structure in PL/pgSQL

2007-06-08 Thread Tom Lane
"Diego Sanchez R." <[EMAIL PROTECTED]> writes: > Is there any way of determining the actual structure of a record variable? Not in plpgsql; even if the info were exposed, you couldn't do anything very useful because that language is strongly typed. In some of the other PLs you could do it --- eg,

Re: [GENERAL] Record Types Structure in PL/pgSQL

2007-06-08 Thread Bart Degryse
Impossible in plpgsql. Use plperl instead. >>> "Diego Sanchez R." <[EMAIL PROTECTED]> 2007-06-08 14:14 >>> Hi there. Is there any way of determining the actual structure of a record variable? E. g. I've written a small script to do some calculations over some fields with a dinamically generated

[GENERAL] Record Types Structure in PL/pgSQL

2007-06-08 Thread Diego Sanchez R.
Hi there. Is there any way of determining the actual structure of a record variable? E. g. I've written a small script to do some calculations over some fields with a dinamically generated query. It looks like this: create function foo(text) returns void as $$ declare a_record record; my_query

Re: [GENERAL] Record Types Structure in PL/pgSQL

2007-06-07 Thread Pavel Stehule
Hello it isn't possible in plpgsql. Try other plperl or plpython Regards Pavel Stehule 2007/6/6, Diego Sanchez <[EMAIL PROTECTED]>: Hi there. Is there any way of determining the actual structure of a record variable? E. g. I've written a small script to do some calculations over some fi

[GENERAL] Record Types Structure in PL/pgSQL

2007-06-07 Thread Diego Sanchez
Hi there. Is there any way of determining the actual structure of a record variable? E. g. I've written a small script to do some calculations over some fields with a dinamically generated query. It looks like this: create function foo(text) returns void as $$ declare a_record record; my_que