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: (view raw or whole 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

In response to


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-2015 The PostgreSQL Global Development Group