Re: [SQL] Breakdown results by month

Henry Ortega wrote: > I have the ff table: > > id |total| effective|end_date > john 6 01-01-200502-28-2005 > john 8 03-01-200506-30-2005 > > How can I return: > id |total| effective

Re: [SQL] NEW and OLD as ROWS

On Wed, Aug 03, 2005 at 12:52:24PM -0500, Craig Servin wrote: > Is there a way to do: > > NEW IS DISTINCT FROM OLD > > in a trigger? > > This would help me not have to write a specific trigger for each table. One way would be to write the trigger function in a language other than PL/pgSQL (PL/T