Re: Simulating sequences

On Monday, Aug 18, 2003, at 09:01 US/Pacific, <btober@seaworthysys.com>
wrote:

> With those items in mind, your function could become:
>
> CREATE FUNCTION key_generation(integer, varchar(20)) RETURNS integer
> AS'
> DECLARE
>   the_department ALIAS FOR $1;
>   the_table_name ALIAS FOR $2;
> BEGIN
>   IF NOT EXISTS(SELECT 1 FROM cnfg_key_generation
>     WHERE the_department = department AND the_table_name = table_name)
> THEN
>    INSERT INTO cnfg_key_generation VALUES
> (the_department,the_table_name,0);
>   END IF;

    I would get the insert out of there, too.  If it doesn't exist, throw
an exception.  I don't believe sequences should automatically create
themselves (the tables and columns don't).

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________