Re: [SQL] Unique key field or serverl fks ?

On Monday 12 January 2004 05:51, katarn wrote: Hi, I would like to know opinions about which approach is better: Having a table with a field that works as a unique key, or having several fks that work as a combined key ( all the fks fields )? Depends on the particular situation, you'll need

[SQL] Triggers

Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? Uzo ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [SQL] Triggers

beyaRecords - The home Urban music wrote: does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? Write a trigger function in, say, PL/PerlU or PL/sh and have it send the email with the

Re: [SQL] Triggers

Dear Uzo , Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? http://pgmail.sourceforge.net/ is what you need. Regards, Vishal Kashyap ---(end of

Re: [SQL] Triggers

On Monday 12 January 2004 16:14, beyaRecords - The home Urban music wrote: Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? Have a look in the mailing list archives - this has

[SQL] Transpose rows to columns

Hi, I have a query that returns data like this: cust_id cust_name month costrevenue margin 991234 ABC 2003-07-01 10 15 5 991234 ABC 2003-08-01 11 17 6 991234 ABC

Re: [SQL] Transpose rows to columns

Hi David On Jan 13, 2004, at 10:12 AM, David Witham wrote: Hi, I have a query that returns data like this: cust_id cust_name month costrevenue margin 991234 ABC 2003-07-01 10 15 5 991234 ABC