Re: [HACKERS] Command execution

2008-07-03 Thread Aaron Spiteri
Thanks for pointers, that has cleared a few things up for me. On 03/07/2008, at 11:27 PM, Csaba Nagy wrote: On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote: Inside foo there was a INSERT and UPDATE, and the INSERT failed but the UPDATE succeeded would the UPDATE be rolled back? Just

[HACKERS] Command execution

2008-07-03 Thread Aaron Spiteri
Hi guys, I have been following the mailing list and reading the source code for a little while, and was wandering if someone could fill in the gaps for me. Does PostgresQL view updates and inserts performed in a function as part of the same transaction or are they considered separate tr

[HACKERS] Numeric Functions

2008-04-22 Thread Aaron Spiteri
I was wandering if there where any intentions of moving some of the currently internal numeric function prototypes to the Numeric header file. I believe such functions like cmp_numerics, add_var, etc would come in handy when writing user defined C code. Would there be many ill effects by do

[HACKERS] Silly Newbie question

2008-02-28 Thread Aaron Spiteri
To all, I am brand new to writing functions for PostgreSQL and understand that this question has been asked one hundred and one times. Please be patient with me, I do learn quickly. My question is: I wish to create a an aggregate function and have read and re-read the 34.10 section of the 8