Re: Datatyp of a column - Mailing list pgsql-hackers

From Ishaya Bhatt
Subject Re: Datatyp of a column
Date
Msg-id CA+E1M321tKzStUui1yr9ELdKKjG2D84f1-fKfaMsaVGH_hN8Ww@mail.gmail.com
Whole thread Raw
In response to Re: Datatyp of a column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Yes!! Thats exactly what I was looking for !! Thanks :)


On Mon, Nov 11, 2013 at 7:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ishaya Bhatt <ishayabhatt@gmail.com> writes:
>      In the sorting code, I need to determine the datatype of my sort keys
> and call some code conditionally based on the datatype. Is there any way to
> determine the datatype of a column from the *backend* PostGreSQL code. is
> the datatype of the column available in the query plan? Any help on this
> would be very much appreciated.

You really need to be more specific about where you need this information.
The "sorting code" certainly knows what datatypes it's working with ---
for example, in tuplesort.c there's a TupleDesc for the tuples passing
through the sort, and the column types are available from the per-column
atttypid fields of that.  But it's not clear if that's what you're talking
about.

                        regards, tom lane

pgsql-hackers by date:

Previous
From: "Colin 't Hart"
Date:
Subject: Re: TABLE not synonymous with SELECT * FROM?
Next
From: Greg Stark
Date:
Subject: Re: Another bug(?) turned up by the llvm optimization checker