Using right() in a view

Hi all,

please foregive me for this rather trivial question, but I´ve worked in it
for quite som time and could use som help now. :)

I have a table where it want to create a idkey using our municipality number
+ the road number + the housenumber.

The municipality and housenumber is in a fixed size, so they are okay. But
the road number differs from two digits up to four. I was then thinking
about doing something like this:

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.

Any idea on how to solve this?

Christian

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Using-right-in-a-view-tp4419141p4419141.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.