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.