Interesting plpgsql function.

Not for me to judge.

I want MAX 2 screens in a single function (a single printed page, easy to flip up and down in a single keypress).

50-80 lines depending on font size and screen size.

This is what I find easiest to achieve a quick state load. And a quick state load means I can jump in and out of the code with minimal brain prep, which in turn means interruptions cost less.

But sometime the damn declarations run a couple of pages.

So if I can externalize the structure definitions and factor out the logic to maintain 2 page boundaries on functions, my code is simply cleaner, easier to read, easier to debug.

In the old days, when I was a novice C programmer (about a year into it on Tandy 6000 Xenix), I had a large function that contained a case statement. This function was in charge of interpreting a command line editorial macro language, and it had a huge number of organically grown exceptions.

When the compiler told me to simplify my code, it was simply too complex for it to handle, I knew I had a problem.

Post #352,755 by mmoffitt 1/5/12 9:23:41 AM Reply	Interesting plpgsql function. 73 Loops, 15 temporary tables, 4400 lines of plpgsql code in one function. Oh, my!
Post #352,765 by lincoln 1/5/12 11:36:42 AM Reply	plpgsql function same as a stored procedure? sounds like it. Used to work with a guy who sent a few years as a contractor with AIG. he said that their programs were done almost entirely inside SQL Server stored procedures; line counts of over 10K were typical. "Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from." -- E.L. Doctorow
Post #352,767 by crazy 1/5/12 1:28:10 PM Reply	DBAs aren't programmers and programmers aren't DBAs Stored procedures are usually written by people who are neither.
Post #352,771 by lincoln 1/5/12 4:16:36 PM Reply	I'm a programmer and have been writing stored procedures in SQL Server for the past 10 years or so. "Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from." -- E.L. Doctorow
Post #352,773 by crazy 1/5/12 6:11:23 PM Reply	I said usually What's the largest number of lines of code you've put in a single procedure?
Post #352,802 by lincoln 1/6/12 8:16:42 AM Reply	around 600 that was the number of lines needed to do what I wanted it to do. "Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from." -- E.L. Doctorow
Post #352,804 by crazy 1/6/12 9:08:11 AM Reply	Painful but possibly required Not for me to judge. I want MAX 2 screens in a single function (a single printed page, easy to flip up and down in a single keypress). 50-80 lines depending on font size and screen size. This is what I find easiest to achieve a quick state load. And a quick state load means I can jump in and out of the code with minimal brain prep, which in turn means interruptions cost less. But sometime the damn declarations run a couple of pages. So if I can externalize the structure definitions and factor out the logic to maintain 2 page boundaries on functions, my code is simply cleaner, easier to read, easier to debug. In the old days, when I was a novice C programmer (about a year into it on Tandy 6000 Xenix), I had a large function that contained a case statement. This function was in charge of interpreting a command line editorial macro language, and it had a huge number of organically grown exceptions. When the compiler told me to simplify my code, it was simply too complex for it to handle, I knew I had a problem.
Post #352,826 by mmoffitt 1/6/12 12:48:42 PM Reply	AIG? Heh. No wonder they needed to be bailed out. ;0)
Post #352,777 by malraux 1/5/12 6:50:30 PM Reply	Amateurs. Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #352,785 by folkert 1/5/12 8:02:09 PM Reply	Don't make me ask you... for proof. I don't want my head to explode! You the one that did Object Oriented Classed programs in SED... Get thee away from that reply button!
Post #352,786 by malraux 1/5/12 8:38:00 PM Reply	Wasn't me that did the evil in question... But I've seen stored procedures that were only broken up once they hit the maximum size. Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #352,787 by crazy 1/5/12 8:51:06 PM Reply	Looking for your OO in any language page Got it up somewhere?
Post #352,789 by Another Scott 1/5/12 9:14:16 PM Reply	Let's see... They were called "shapes" examples. http://onestepback.o.../poly/oo-lpc.html is one. That's the only one that jumps up in my quick search. HTH a little. Cheers, Scott.
Post #352,790 by malraux 1/5/12 9:34:18 PM Reply	Re: Looking for your OO in any language page http://onestepback.org./articles/poly/index.html Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #352,798 by pwhysall 1/6/12 7:32:52 AM Reply	Re: Looking for your OO in any language page Ah, a useful reminder that there's something wrong in your head, Anderson.
Post #352,833 by malraux 1/6/12 2:28:33 PM Reply	Who needs a reminder...? Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #352,799 by crazy 1/6/12 7:39:49 AM Reply	The boy spent a month in straight DP style perl And then another month moving toward some OO aspects. He likes OO. He also likes Lisp. Strange fucker, ain't he? And then the job said: PERL MUST DIE - Rewrite EVERYTHING in C#. So he spent the last month in C#. I figure he's now ready for exposure to your code. It'll hurt his head, but then it will be worth it.
Post #352,834 by malraux 1/6/12 2:29:50 PM Reply	Re: The boy spent a month in straight DP style perl Heh... I am frightened that that stuff is considered training material by anyone... Make sure you also tell him, "if you ever write something like this I will kill you." Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #352,835 by drook 1/6/12 3:21:32 PM Reply	Specifically: Just because you can don't mean you should -- Drew
Post #352,837 by Another Scott 1/6/12 3:30:51 PM 1/6/12 3:33:25 PM Reply	Ack! [edit:] Wrong thread! Sorry! Cheers, Scott. Edited by Another Scott Jan. 6, 2012, 03:33:25 PM EST Expand All History

Welcome to IWETHEY!