Re: FW: execute dynamic strings. need help. - Mailing list pgsql-general

From Richard Huxton
Subject Re: FW: execute dynamic strings. need help.
Date
Msg-id 421B793F.4080400@archonet.com
Whole thread Raw
In response to Re: FW: execute dynamic strings. need help.  (Stefan.Ardeleanu@siveco.ro)
List pgsql-general
Stefan.Ardeleanu@siveco.ro wrote:
> Thank you very, very much. It works.
> Do you know if exista another similar possibility do resolve this problem
> without need to know the columns types?

Well, you could cast all the output columns to type text, then you'd
only need to know how many columns there were. Otherwise, no - the
system needs to know what types are involved either from the function or
the query itself.

> In JDBC, when calling this function, you have to know these column types?

No idea if it works with JDBC I'm afraid. You'll have to give it a try.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuuming slow
Next
From: Shachar Shemesh
Date:
Subject: Re: ADO and timestamp/date errors