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.
"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,
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
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
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
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