All Questions
6 questions
6
votes
1
answer
1k
views
Univariate analysis with SQL stored procedure
I wrote a SQL univariate analysis stored procedure taking as input a schemaname and a tablename on PostgreSQL. It is exactly like a PROC SAS UNIVARIATE. As output, you get less than 20 usable ...
user154411
3
votes
1
answer
46
views
Creating a join table entry by looking up name
I wrote a stored procedure that allows a join entity to be created by name for my fictional characters database. I would like some feedback on it with regard to exception handling, and conditions I ...
- 915
2
votes
0
answers
514
views
Function to split a given string according to predefined patterns
Here's a function that splits given string according to predefined patterns. It's part of a trigger function used to populate one table from another. I want to be sure that I'm not making any mistakes....
- 21
7
votes
3
answers
165
views
Step 2: Creating functions the business tool will use
I've been working on this project and here is my first function for step 2. I feel this is the most important one, as I will carry over recommendations from this ...
- 20.5k
48
votes
2
answers
4k
views
Tired of FizzBuzz yet?
There have been many FizzBuzz questions lately, and here is one more! Granted, it is pretty straightforward to do FizzBuzz with SQL using calculations.
So instead, I'm going to do a FizzBuzz which ...
- 20.5k
5
votes
1
answer
110
views
Selecting and copying event log entries for some machine
I have a PL/pgSQL function with erratic performance:
...
- 59