2011-06-23 20:44 keltezéssel, Gurjeet Singh írta: > On Wed, Jun 22, 2011 at 3:37 PM, Joshua D. Drake <j...@commandprompt.com > <mailto:j...@commandprompt.com>> wrote: > > Per: > > http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php > > It seems we did come up with a use case in the procpid discussion. The > ability to > change the names of columns/databases etc, to handle the fixing of bad > decision > decisions during development over time. > > Thoughts? > > > Instead of just synonyms of columns, why don't we think about implementing > virtual > columns (feature as named in other RDBMS). This is the ability to define a > column in a > table which is derived using an expression around other non-virtual columns. > I agree it > would be much more difficult and some may even argue it is pointless in the > presence of > views and expression indexes, but I leave that as an exercise for others.
A few years ago I wrote a patch for (I think) 8.2 that implemented IDENTITY and GENERATED columns. Look it up in the archives. The "virtual" column is called GENERATED in the SQL standard and is part of the table and maintained as a function/expression of other fields in the same record. Best regards, Zoltán Böszörményi -- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de http://www.postgresql.at/