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

Re: SQL Functions

From: "Raymond Auge" <RX_Auge(at)nickel(dot)laurentian(dot)ca>
To: <pgsql-admin(at)postgresql(dot)org>, <postgres(at)productivitymedia(dot)com>
Subject: Re: SQL Functions
Date: 2004-10-19 15:38:38
Message-ID: s174fcdc.066@luadmn2.laurentian.ca (view raw or flat)
Thread:
Lists: pgsql-admin
Hello Postgres User,

I'd have to say that functions have the same "function" in SQL as they do in any language; a logical grouping of often repeated opperations.

So, if you have a repeated sequence like

query1(args);
if(result of query1 does this){
 query2(args);
}
else{
 query3(args);
}

then consider that you have 3 transactions with the database.

But, if all that was put into a SQL function, you have 1 transaction; "functions in SQL are atomic".

As well, in you code you have

sql_function(args);

and that's it...

clean and very fast.

--------------------------------------------------------------
Raymond Augé, B.COSC
Spécialiste en médiatisation de la formation/Multimedia specialist
Université Laurentienne / Laurentian University
<rx_auge(at)laurentienne(dot)ca> / <rx_auge(at)laurentian(dot)ca> 
(705) 675-1151 x3934


>>> Postgres User <postgres(at)productivitymedia(dot)com> 19/10/2004 11:12:47 am >>>
What are the advantages to SQL Functions?  I'm looking to optimize 
'default' PostgreSQL environments for clients. I'm writing an 
application and looking to put functions to optimize just that table, 
etc. They don't want to have a full-time database admin (surprise!).

Thanks,
J

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


pgsql-admin by date

Next:From: Tom LaneDate: 2004-10-19 15:51:21
Subject: Re: postmaster stopps
Previous:From: Andrew SullivanDate: 2004-10-19 15:28:46
Subject: Re: postmaster stopps

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