On Friday, May 14, 2021, Durumdara <durumd...@gmail.com> wrote:

>
> Is there any way to suppress the original field?
>

Remove the star and list the other columns you do want.


>
> Or say to PGSQL to skip the first XDate field?
>

> Like select t.* (EXCEPT XDate) from t
>

No, though I’ve expressed a desire for this in the past as well.


>
> Or can I reference them by the order?
>

No


>
> Ok, I can solve this problem by renaming the new first XDate, but I want
> to know is there any solution to this problem?
>

No, you need to rename one of them.

David J.

Reply via email to