Re: Cast in PG 8.3

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: Franklin Haut <franklin(dot)haut(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Cast in PG 8.3
Date: 2008-02-05 22:39:39
Message-ID: 87d4rbm3is.fsf@ttmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Franklin Haut <franklin(dot)haut(at)gmail(dot)com> writes:
> I Tries create a cast but the function text doesn't exist more in PG 8.3

sql-createcast.html tells that

"It is normally not necessary to create casts between user-defined
types and the standard string types (text, varchar, and
char(n)). PostgreSQL will automatically handle a cast to a string
type by invoking the other type's output function, ..."

Therefore, this might help you:

test=# SELECT typoutput FROM pg_type WHERE typname = 'int4';
typoutput
-----------
int4out
(1 row)

Regards.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jyoti Seth 2008-02-06 06:21:10 Multiple postgresql functions in a single transaction
Previous Message Tom Lane 2008-02-05 21:23:25 Re: Negative numbers for PK/ID's?