am Wed, dem 12.11.2008, um 8:08:08 +0100 mailte Csaba Együd folgendes: > Hi All, > > --PG8.3 > --Windows 2k3 SBS > > I would like to apply an automatic filter condition to a table. I create a > TEMP table at the beginning of the session to store a value to build up a > filter condition and I would like to apply this condition to every select > statement to a table during the current session. > I know that I could use views but views are read only and I also need Update > and Insert. You can define RULEs on insert and update on a view to do real insert/update on the base-table. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
