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

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Followup from yesterday's PL/pgSQL fun...
Date: 2003-05-14 16:41:39
Message-ID: 177190000.1052930499@lerlaptop-red.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I posted:

Also, this is what I wound up with for that line, which seems ugly, because
it couldn't find a quote_literal(inet) without the ::text on it:

quote_literal(NEW.netblock::inet::text) ;

Is that right?

Can I ask 3 questions:

1) should quote_literal find a ::text conversion on it's own?
2) can text(cidr) be added to the default pg_cast table?
3) how can I add text(cidr) myself?

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Sousa 2003-05-14 16:46:17 Re: Can arrays reference primary keys in CREATE TABLE?
Previous Message Richard Huxton 2003-05-14 16:32:11 Re: Type coercion on column in a query