Re: Cosmetically-varying casts added to view definitions

On 07/30/2018 02:26 PM, Ken Tanzer wrote:

> This doesn't impair the view's functionality, so I can't necessarily
> complain.  But it does make it harder for me to know if the views were
> recreated correctly.  I'd be curious to know what is going on here, and
> if there's any way to avoid this behavior.

The only way I can think of to maintain a consistent definition is to
always create the view from the original definition:

CREATE VIEW test_tmp AS (SELECT 1 FROM l_payment_form WHERE
payment_form_code IN ('CREDIT_CARD','OTHER'));