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
<[EMAIL PROTECTED]> / <[EMAIL PROTECTED]>
(705) 675-1151 x3934
>>> Postgres User <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
