Is there a way to replace select * fields in result ? - Mailing list pgsql-general

From Condor
Subject Is there a way to replace select * fields in result ?
Date
Msg-id 37a2bc0c7c8e90ea7620297e8d23515a@stz-bg.com
Whole thread Raw
Responses Re: Is there a way to replace select * fields in result ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Is there a way to replace select * fields in result ?  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Hello,

Is there a way to replace select * fileds in result ?
I have select qw.* from table but I want field for example mm to be 
replaced with custom value like:

select qw.*, case whem length(qw.mm) > 0 THEN COALESCE(SUBSTRING(qw.mm, 
1, 1), '') ELSE qw.mm END AS qw.mm

Is there some way to do that ?

Regards,
HS



pgsql-general by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: bottom / top posting
Next
From: "David G. Johnston"
Date:
Subject: Re: Is there a way to replace select * fields in result ?