Re: Followup from yesterday's PL/pgSQL fun... - Mailing list pgsql-sql

From Tom Lane
Subject Re: Followup from yesterday's PL/pgSQL fun...
Date
Msg-id 25250.1052931519@sss.pgh.pa.us
Whole thread Raw
In response to Followup from yesterday's PL/pgSQL fun...  (Larry Rosenman <ler@lerctr.org>)
Responses Re: Followup from yesterday's PL/pgSQL fun...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Larry Rosenman <ler@lerctr.org> writes:
> 1) should quote_literal find a ::text conversion on it's own?

It won't, because the pg_cast entry for inet->text is marked "explicit
casts only".  In general I don't like implicit casts across datatype
categories, and am hoping to move in the direction of marking more such
casts as explicit-only.

> 2) can text(cidr) be added to the default pg_cast table?

I'll make that happen for 7.4.

> 3) how can I add text(cidr) myself?

Read the pg_cast description in 
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=catalogs.html
Insert a suitable row.
        regards, tom lane


pgsql-sql by date:

Previous
From: Luis Sousa
Date:
Subject: Re: bad query performance
Next
From: Tom Lane
Date:
Subject: Re: Followup from yesterday's PL/pgSQL fun...