Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
Thanks. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: 09 December 2014 21:46 To: FarjadFarid(ChkNet); 'David G Johnston'; pgsql-general@postgresql.org Subject: Re: [GENERAL] List of shorthand casts On 12/09/2014 01:37 PM, FarjadFarid(Chk

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
Got it thanks. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane Sent: 09 December 2014 21:40 To: FarjadFarid(ChkNet) Cc: 'David G Johnston'; pgsql-general@postgresql.org Subject: Re: [GENERA

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread Adrian Klaver
ge- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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 s

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread Tom Lane
"FarjadFarid\(ChkNet\)" writes: > 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. Any type name works fine after "::".

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread FarjadFarid(ChkNet)
ge- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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 docum

Re: [GENERAL] List of shorthand casts

2014-12-09 Thread David G Johnston
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