Re: [Review] Tests citext casts by David Wheeler. - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: [Review] Tests citext casts by David Wheeler.
Date
Msg-id 849C78CC-AD60-4DDA-97C9-9B5595192AAC@kineticode.com
Whole thread Raw
In response to Re: [Review] Tests citext casts by David Wheeler.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Review] Tests citext casts by David Wheeler.  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Sep 12, 2008, at 10:58, Tom Lane wrote:

>> 1. Did I neglect to include the documentation patch? I've attached it
>> here. It's necessary because of the addition of the new functions.
>
> Maybe it got left out of the later patch iterations?  Anyway,
> will take care of it.

Great, thank you.

>> 2. Many thanks for switching to using the network_show function
>> instead of the SQL-based casting I had. Can you tell me how to go
>> about finding such functions?
>
> 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!

Best,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Review] Tests citext casts by David Wheeler.
Next
From: "David E. Wheeler"
Date:
Subject: Re: [Review] Tests citext casts by David Wheeler.