| From: | Peter Bex <Peter(dot)Bex(at)xs4all(dot)nl> |
|---|---|
| To: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Prepared statements and unknown types |
| Date: | 2010-09-29 18:41:42 |
| Message-ID: | 20100929184142.GN17624@frohike.homeunix.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2010-09-29 18:51:11 | Re: Prepared statements and unknown types |
| Previous Message | Steve Crawford | 2010-09-29 18:36:14 | Re: psql copy command - 1 char limitation on delimiter |