Re: FW: execute dynamic strings. need help.

From: Richard Huxton <dev(at)archonet(dot)com>
To: Stefan(dot)Ardeleanu(at)siveco(dot)ro
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: execute dynamic strings. need help.
Date: 2005-02-22 18:26:07
Message-ID: 421B793F.4080400@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stefan(dot)Ardeleanu(at)siveco(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shachar Shemesh 2005-02-22 19:26:47 Re: ADO and timestamp/date errors
Previous Message Tom Lane 2005-02-22 18:23:24 Re: vacuuming slow