Re: [SQL] Triggers using PL/pgSQL

Hello,Thanks a lot Aaron for the very quick and simple example. I just checked it on 7.4.5 also and it worked. I'll be able to continue with my development using  the syntax of that example.Regards,-ThusithaAaron Bono <[EMAIL PROTECTED]> wrote: On 7/30/06, Thusitha Kodikara <[E

[SQL] Triggers using PL/pgSQL

Hello,I am interested in developing some triggers to keep track of records that are changed (possibly the changes of one or more specific columns). In addition to keeping the new values, I also need to keep the old values (may be on a separate table).  Though I  have done similar things in other RD

Re: [SQL] Encryption functions

Thanks for the guidance .-Thusitha"D'Arcy J.M. Cain" wrote: On Thu, 18 May 2006 06:44:55 -0600Michael Fuhr <[EMAIL PROTECTED]> wrote:> On Thu, May 18, 2006 at 04:21:19AM -0700, Thusitha Kodikara wrote:> > Are there any encryption functions that can be used in> &

Re: [SQL] Encryption functions

Thanks Michael, I'll check that module.Michael Fuhr <[EMAIL PROTECTED]> wrote: On Thu, May 18, 2006 at 04:21:19AM -0700, Thusitha Kodikara wrote:> Are there any encryption functions that can be used in> SQL inserts and selects directly? For example like> "

[SQL] Encryption functions

Hi,Are there any encryption functions that can be used in SQL inserts and selects directly ? For example like "select encryptin_function('test_to_be_encrypted'), "Thanks and regards,-Thusitha

Re: [SQL] grant select on database demo to user

Hi,You could easily generate a script with the list of tables and the required grant information and then run it to give the necessary grants. (The list of tables may be obtained by querying tables in 'information_schema')Regards,-Thusitha -Original Message- From: [EMAIL PROTECTED] [mailto