From: Tom Lane <tgl@sss.pgh.pa.us>
To: Larry Rosenman <ler@lerctr.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Followup from yesterday's PL/pgSQL fun...
Date: Wed, 14 May 2003 12:58:39 -0400
Message-ID: <25250.1052931519@sss.pgh.pa.us> (raw)
In-Reply-To: <177190000.1052930499@lerlaptop-red.iadfw.net>
References: <177190000.1052930499@lerlaptop-red.iadfw.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, ler@lerctr.org
Subject: Re: Followup from yesterday's PL/pgSQL fun...
In-Reply-To: <25250.1052931519@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox