From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, mark(at)mark(dot)mielke(dot)cc, Thomas Hallgren <thomas(at)tada(dot)se>, Josh Berkus <josh(at)agliodbs(dot)com>, "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Fixed length datatypes. WAS [GENERAL] UUID's as |
Date: | 2006-07-01 15:24:33 |
Message-ID: | 24254.1151767473@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Something that has been discussed in the past is allowing non-strict
> type input/output functions to be evaluated at query execution time,
> rather than during parse time. This would give the type input/output
> functions the Expr node they need to extract this info.
We could make that happen for literals used in queries (see comment in
coerce_type()), but it's not appealing to expect all of the ad-hoc I/O
function calls in the whole system to supply dummy expression trees.
That would be adding overhead to all cases that's only useful in a few.
I think requiring the functions that need this info to do extra work
is probably the right answer. (It's already possible to cache whatever
lookups you have to do, cf array_in or record_in, so the overhead isn't
*that* daunting.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2006-07-01 15:46:33 | Re: db question - dynamic fields in db |
Previous Message | Tom Lane | 2006-07-01 15:15:24 | Re: Fixed length datatypes. WAS [GENERAL] UUID's as |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-07-01 18:59:54 | Re: optimizing constant quals within outer joins |
Previous Message | Tom Lane | 2006-07-01 15:15:24 | Re: Fixed length datatypes. WAS [GENERAL] UUID's as |