Re: Dynamic Query problem - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Dynamic Query problem
Date
Msg-id Pine.BSF.4.21.0109291118350.33581-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Dynamic Query problem  ("Dinesh Parikh" <dineshp@newgen.co.in>)
List pgsql-general
On Sat, 29 Sep 2001, Dinesh Parikh wrote:

> Hi,
> Actually I think there is some type of caching in record datatype. Is there
> any way to find datatype of record's column so that i can explicit cast in
> assignment(have u propse alternate of this).

Well, you could explicitly cast in the select query string to the type you
want it to be. Something like:
''Select '' || DBColName || ''::<type> As Field '' || '' From TestTable''
where <type> is the type you want out.



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: trigger compile problem
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Encoding passwords