Re: List of shorthand casts - Mailing list pgsql-general

From FarjadFarid\(ChkNet\)
Subject Re: List of shorthand casts
Date
Msg-id 009c01d013f8$5c35ef00$14a1cd00$@checknetworks.com
Whole thread Raw
In response to Re: List of shorthand casts  (David G Johnston <david.g.johnston@gmail.com>)
Responses Re: List of shorthand casts
Re: List of shorthand casts
List pgsql-general
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.

Many thank.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of David G Johnston
Sent: 09 December 2014 20:23
To: pgsql-general@postgresql.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.





--
View this message in context:
http://postgresql.nabble.com/List-of-shorthand-casts-tp5829791p5829795.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Updating single/multiple fields of JSON document
Next
From: Tom Lane
Date:
Subject: Re: List of shorthand casts