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
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
-
