Re: Using right() in a view - Mailing list pgsql-general

Chrishelring wrote:
>
> CREATE OR REPLACE VIEW test AS
> SELECT
>   right(cast('000' as text) || cast(road_number as text), 4) AS GEO_ADRESSE
>
> FROM rk_ois.bbrbygning
> WHERE ejerlav <> 0
>
> to ensure that the road_number would be a fixed size (four digitis).
> Unfortunately this doesn't work.

Try using:
   select to_char(road_number, 'FM0000') as GEO_ADRESSE

HTH

Bosco.