On 07/30/2015 09:51 AM, Tom Lane wrote:
> Joe Conway <mail@joeconway.com> writes:
>> What about just TYPE then?
>
>> SELECT x::TYPE(some_expression) FROM ...
>> SELECT CAST (x AS TYPE(some_expression)) FROM ...
> The main limitation of this patch is that it won't work for call sites
> that pass pstate == NULL to LookupTypeName. There are a fair number
> of them, some of which wouldn't care because they could never invoke
> this notation anyway, but for others we'd need to do some work to cons
> up a suitable pstate.
Sorry it took so long for me to get back to this, but any reason the
attached won't work?
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development