Ron,
Thank you – that got me past that. I thought I had used a variable before with
no joy but I probably had other issues.
Hopefully, I am on my way now.
Thanks again,
Jim
From: Ron Johnson
Sent: Tuesday, August 13, 2024 12:06 PM
To: pgsql-generallists.postgresql.org
Subjec
I have a simple 3 column table. The Table is a Month Name to number table
which also includes an effective date column. So 12 rows, 3 columns each.
Here is the Stored Procedure I constructed to get the number if given the
name (3 parameters for the SP):
--/
DROP PROCEDURE month_lookup
