phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Add pseudo columns to an existing view
Date Fri, 31 Jul 2020 14:23:22 GMT
Yes. Please see the docs which illustrate how to create views.

On 7/28/20 2:12 AM, Arun J wrote:
> Team,
> Can we create or alter a view to add a column which is pseudo columns 
> such as
> 
> # FULLNAME from other columns such as FIRSTNAME + LASTNAME
> # NUMVALUE from other columns TO_NUMBER(STRVALUE)
> 
> This would be quite helpful to avoid changing data types everytime in 
> the client query.
> 
> Thanks in advance.
> JAK

Mime
View raw message