Chrishelring wrote on 10.06.2011 22:45:
HI all,
below is the view iÂve tried to create on a table. The purpose was to do
some math on one of the columns (retning). The column is a double precision
number. The result is that the function is not recognized ("ERROR: function
to_number(double precision, unknown) does not exist"). IÂm a bit uncertain
on how the syntax is, so perhaps someone could point me in the right
direction?
If the column is already a numeric data type there is no reason to use to_number() (which converts a character value to a number)
CREATE OR REPLACE VIEW "husnr_view" ("KOMNR", "VEJKODE", "VEJNAVN",
"HUSNUMMER", "POSTNR", "POSTNAVN", "X", "Y", "RETNING", "TSTAND", "NKLASSE")
AS
SELECT
HUSNR.KOMNR KOMNR,
HUSNR.VEJKODE VEJKODE,
HUSNR.VEJNAVN VEJNAVN,
HUSNUMMER,
HUSNR.POSTNR POSTNR,
HUSNR.POSTNAVN POSTNAVN,
HUSNR.X X,
HUSNR.Y Y,
CASE
WHEN HUSNR.RETNING < 20000 THEN (20000- HUSNR.RETNING)/111
WHEN HUSNR.RETNING > 20000 THEN (40000- (HUSNR.RETNING -20000))/111
END RETNING,
HUSNR.TSTAND TSTAND,
HUSNR.NKLASSE NKLASSE
FROM rk_grundkort.husnr;
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
