Re: List of shorthand casts

On 12/09/2014 01:37 PM, FarjadFarid(ChkNet) wrote:
> Hi David,
>
> I mean the ones with "::" like ::text or ::uuid etc
>
> Some of Postgresql data types have two words or more like "double precision"
> or " timestamp without time zone". It is not clear how these are
> implemented if at all.

Try the query below to get most of the casts available:

select castsource::regtype, casttarget::regtype from pg_cast order by
castsource;

For more info and caveats see:

http://www.postgresql.org/docs/9.3/interactive/catalog-pg-cast.html

>
> Many thank.
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of David G Johnston
> Sent: 09 December 2014 20:23
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] List of shorthand casts
>
> FarjadFarid(ChkNet) wrote
>> Is the list of shorthand casts documented somewhere?
>> If so can you please direct me to it. A working URL would be great.
>
> Do you mean implicit casts - those that do not require an explicit CAST(...)
> or "::" in the query?
>
> Can you give an example of one that you know exists?
>
> The catalog is probably the best way to get a definitive list though I do
> not know the exact query you would use. The catalog tables are fairly well
> documented so you should start there.
>
> David J.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com