[GENERAL] Changing pg_type records

2009-03-19 Thread Rob Richardson
Greetings! I just discovered the existence of a couple of functions I don't understand in one customer's PostgreSQL database: -- Function: c_mode() -- DROP FUNCTION c_mode(); CREATE OR REPLACE FUNCTION c_mode() RETURNS text AS $BODY$ UPDATE pg_type SET typoutput='c_textout'WHERE

Re: [GENERAL] Changing pg_type records

2009-03-19 Thread Tom Lane
Rob Richardson rob.richard...@rad-con.com writes: I just discovered the existence of a couple of functions I don't understand in one customer's PostgreSQL database: What do the substitute output functions do differently? UPDATE pg_type SET typoutput='c_textout'WHERE typname='SET'; This