RE: Novice with Postgresql - trying simple Stored Procedure

2024-08-13 Thread jim.kosloskey
Subject: Re: Novice with Postgresql - trying simple Stored Procedure On Tue, Aug 13, 2024 at 11:32 AM mailto:jim.koslos...@jim-kosloskey.com> > wrote: 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 column

Re: Novice with Postgresql - trying simple Stored Procedure

2024-08-13 Thread Ron Johnson
On Tue, Aug 13, 2024 at 11:32 AM wrote: > 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 fo

Novice with Postgresql - trying simple Stored Procedure

2024-08-13 Thread jim.kosloskey
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