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

Re: Extended customizing, SQL functions,

From: Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
To: pgsql(at)mohawksoft(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extended customizing, SQL functions,
Date: 2004-05-29 00:13:28
Message-ID: 200405281713.28537.jgardner@jonathangardner.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Friday 28 May 2004 04:08 pm, pgsql(at)mohawksoft(dot)com wrote:
>
> No transactions.
>

Then it won't work. Let's say we take your example. The variable "s" is 
supposed to be the sum of a column in a table.

When someone modifies the data in the table, when is "s" adjusted? What if 
it is modified but the transaction is aborted? Who sees the "correct" value 
of "s" at any point in time?

-- 
Jonathan Gardner
jgardner(at)jonathangardner(dot)net

In response to

Responses

pgsql-hackers by date

Next:From: Gaetano MendolaDate: 2004-05-29 00:13:30
Subject: false infinite recursion detected
Previous:From: Gaetano MendolaDate: 2004-05-28 23:59:03
Subject: passing a whole record variable into a SQL command is not implemented

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