| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ryan Bradetich <rbradetich(at)gmail(dot)com> |
| Subject: | Re: [Review] Tests citext casts by David Wheeler. |
| Date: | 2008-09-12 18:14:00 |
| Message-ID: | F493CAA7-8D82-45B6-9C9B-925639920644@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sep 12, 2008, at 11:06, David E. Wheeler wrote:
>> Er, look into pg_cast and then pg_proc? For instance
>>
>> select oid::regprocedure, prosrc from pg_proc
>> where oid in (select castfunc from pg_cast);
>
> That looks like *exactly* what I need. Thanks!
Pity. Looks like there were only a few I wasn't using, text_char,
char_text, text_name, and texttoxml. Do I really need to keep all my
other casts like these in 8.3?
CREATE OR REPLACE FUNCTION int8(citext)
RETURNS int8
AS 'SELECT int8( $1::text )'
LANGUAGE SQL IMMUTABLE STRICT;
CREATE OR REPLACE FUNCTION citext(int8)
RETURNS citext
AS 'SELECT text( $1 )::citext'
LANGUAGE SQL IMMUTABLE STRICT;
Thanks,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-09-12 18:14:21 | Re: [HACKERS] Infrastructure changes for recovery |
| Previous Message | David E. Wheeler | 2008-09-12 18:06:42 | Re: [Review] Tests citext casts by David Wheeler. |