Skip site navigation (1) Skip section navigation (2)

Re: Excluding null values

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Excluding null values
Date: 2002-03-17 22:40:19
Message-ID: web-831111@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
Sharon,

> I think the best idea for this scenario is a trigger, I had a go at
>  writing one for this but since a trigger runs for each row my
>  function code did not work.

OK.  When I get back to my office, I'll send some sample code; I have a
 trigger I use all the time for this purpose.

-Josh

pgsql-novice by date

Next:From: Richard A LoughDate: 2002-03-18 14:02:22
Subject: Estimating Database Disk Space
Previous:From: Tom LaneDate: 2002-03-17 21:42:08
Subject: Re: Database is shutting down

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group