Re: [SQL] Rules aren't doing what I expect

On Wed, Aug 09, 2000 at 12:04:13PM -0400, Mark Volpe wrote: > I have a table with a trigger that can potentially modify a row before it gets > inserted or updated: [snip] > I have another table that tracks changes in the first table with rules: AFAIK, rules get rewritten first, before triggers

[SQL] Rules aren't doing what I expect

Hi again, I have a table with a trigger that can potentially modify a row before it gets inserted or updated: CREATE TABLE t1 (a int); CREATE FUNCTION t1_validate() RETURNS opaque AS ' BEGIN IF (NEW.a>10) THEN NEW.a=10; END IF;

[SQL] any tool "return query results to a grid "

Hi Any tool/class [C source code] to "return query results to a grid" regarding Pgsql ? Thanks Lucian

Re: [SQL] Aggregate functions, fast! (long)

On Wed, Aug 09, 2000 at 02:53:45PM +0800, Ang Chin Han wrote: > The queries making use of these might be rewritten as: > 1. select min(a) from t_sum; -- same as above, > -- but we've less rows to scan > 2. select cnt from t_sum where a = 1 and b = 3; Sorry,

[SQL] Aggregate functions, fast! (long)

Apologies in advance for the length of this post, but this has been bugging me for a week or so. Consider a table with a primary key pk and a list of attributes a, b and c: Table t pk a b c --- 1 1 1 1 2 1 2 3 : etc : 9998 1 1 1 2 1