Re: Followup from yesterday's PL/pgSQL fun...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Followup from yesterday's PL/pgSQL fun...
Date: 2003-05-14 16:58:39
Message-ID: 25250.1052931519@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Larry Rosenman <ler(at)lerctr(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-05-14 17:02:48 Re: Followup from yesterday's PL/pgSQL fun...
Previous Message Luis Sousa 2003-05-14 16:54:30 Re: bad query performance