Hello, Imagine we have the following kind of table, with two values (a and b), and a varchar (f) representing an expression.
---------------------------------- CREATE TABLE public.test ( id serial NOT NULL, a int4, b int4, f varchar(50), CONSTRAINT id PRIMARY KEY (id) ) WITHOUT OIDS; INSERT INTO public.test(a,b,f) VALUES(2,3,'a+b'); INSERT INTO public.test(a,b,f) VALUES(12,3,'a*b'); INSERT INTO public.test(a,b,f) VALUES(5,6,'a+2*b'); ---------------------------------- Is there a simple way of doing "kind of" a SELECT *, EVAL(f) FROM public.test; ... and having f evaluated as an expression, so that we get back: ------------------------------ id a b f eval ------------------------------ 1 2 3 a+b 5 2 12 3 a*b 36 3 5 6 a+2*b 17 ------------------------------ Has anyone done anything like that already? Thanks! Philippe ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
