virtual fields on VIEW?
От | raptor@tvskat.net |
---|---|
Тема | virtual fields on VIEW? |
Дата | |
Msg-id | 20040618161338.4ebf6406@bugs обсуждение исходный текст |
Ответы |
Re: virtual fields on VIEW?
Re: virtual fields on VIEW? Re: virtual fields on VIEW? |
Список | pgsql-general |
hi, I want to make the following thing : select-based updatable VIEW, which have two more virtual-fields. One of them is concatenation of others and the second is calculated on the fly. Can I do this and if yes how? can u give some example? Here is the test bed : table1) id, date, field1, field2 table2) id, fieldA, fieldB, fkID now I want to make a view that is create view as select t1.id, t1.date, t1.field1, t1.field2, t2.fieldA, t2.fieldB, state, stuff from table1 as t1, table2 as t2 where t1.id = t2.fkID >> WHERE "state" is caluclated like this : state = 'red' if date > today state = 'green' if date < today state = 'blue' unless date >> AND 'stuff' is concatenation of t1.field2 and t2.fieldA. >> BOTH state and stuff will be only available for SELECTs on the view i.e. they are not updatable .. can this be done, if yes how. tia
В списке pgsql-general по дате отправления: