Re: Prepared statements and unknown types - Mailing list pgsql-general

From Peter Bex
Subject Re: Prepared statements and unknown types
Date
Msg-id 20100929184142.GN17624@frohike.homeunix.org
Whole thread Raw
In response to Re: Prepared statements and unknown types  (Thom Brown <thom@linux.com>)
Responses Re: Prepared statements and unknown types  (Thom Brown <thom@linux.com>)
Re: Prepared statements and unknown types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
> Okay, I understand what's happening.  But does the planner need to
> understand the type of literals in the select list if it's not used
> anywhere else?

Fields sent back to the client also carry their type with them.
There's no "unknown" type (and it wouldn't be very useful in any
case, because how would you go about displaying an unknown type?)

Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
 is especially attractive, not only because it can be economically
 and scientifically rewarding, but also because it can be an aesthetic
 experience much like composing poetry or music."
                            -- Donald Knuth

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: psql copy command - 1 char limitation on delimiter
Next
From: Thom Brown
Date:
Subject: Re: Prepared statements and unknown types