Re: plPerl subroutine - Mailing list pgsql-general

From Tom Lane
Subject Re: plPerl subroutine
Date
Msg-id 6188.1110987237@sss.pgh.pa.us
Whole thread Raw
In response to plPerl subroutine  ("FERREIRA William (COFRAMI)" <william.ferreira@airbus.com>)
List pgsql-general
"FERREIRA William (COFRAMI)" <william.ferreira@airbus.com> writes:
> but the CREATE_XML_FILE doesn't display 'totototototototototot' but
> HASH(0xf03fa4)....

I think what you get back from spi_exec_query is always going to be
a hash, even if it contains only one field.  So you need to pick out
the field value.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 2 questions about types
Next
From: Michael Fuhr
Date:
Subject: Re: New user: Windows, Postgresql, Python