Re: dblink: add polymorphic functions. - Mailing list pgsql-hackers

From Joe Conway
Subject Re: dblink: add polymorphic functions.
Date
Msg-id 55B9AAF9.4010206@joeconway.com
Whole thread Raw
In response to Re: dblink: add polymorphic functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dblink: add polymorphic functions.  (Corey Huinker <corey.huinker@gmail.com>)
Re: dblink: add polymorphic functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/29/2015 07:58 PM, Tom Lane wrote:
> We can definitely do
> 
> SELECT x::any_single_unreserved_word(some_expression) FROM ...
> 
> because that's actually not something the grammar needs to
> distinguish from type-with-a-typmod; we can deal with the special
> case in LookupTypeName.  It's just a matter of picking a word
> people like.

What about just TYPE then?
   SELECT x::TYPE(some_expression) FROM ...   SELECT CAST (x AS TYPE(some_expression)) FROM ...

- -- 
Joe Conway
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQIcBAEBAgAGBQJVuar5AAoJEDfy90M199hlN8gP/i2IdtOsJ1PasKfUjAegbHf5
HIWLI7lZw2OMb451zrrNJbfTk1xY+OUJX8tRTLku8GyoZ9FrhDnBo0JuZuHMQOo4
ulWPH7JYGQVb89FYANNbubIehfJ0Y5TCr/ihkpmeVR6sTR3OZDSvdVtymF34wfZE
96i2S6QqWHN4V6hNXjTuzaIu4BXFXvZg3N9yNvBRrpnif53jfKPnca6wSeHJgTWv
w8L6mKQbLDW+5azVmuFX/1PyLxMRphsZL6G4+yyASkzQP2VOGDRQrM4Uavoot9Ja
l1Ez4bBoK3ERxfovnSWfwlsqhKmQ41TijoIu/Ex/s1O3dL2LVQ2qBp8cCl8pX9zq
Fnk11ueAvjkVt8/mIQFkGY+noes8vqWGe6yB0FYXjJvFfL4DXgfmthdyyCGJM1l9
JLI034tkflXKEkk5Ty9gOeAaMzqztqmIRYoQKK7O18DOKNH3Fgoa5Vh2Fz/iJI6G
rjQtfcZwv6ukN0qyQ8QB42CvLJVQ5KVwdTSr/93eCipSIuTPJNEoIBSh7H02WN7Q
fqQcKsM9m9ZTkAYP9uQCMEwusiKoPZt41Tdwf5fbhuOHoSim2Tab63eMEoUkRsqu
Bgqql/U5/MRsoAoDp4ALr2LbugnnTVNhrqrP58e45yl+694UEyh9XRpZmWUpX9Lw
k+qPyOJCnLBwOcmS0tv1
=+T37
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Division by zero in planner.c:grouping_planner()
Next
From: Beena Emerson
Date:
Subject: Re: Support for N synchronous standby servers - take 2