On Sun, 2004-11-07 at 17:21, John Hansen wrote:
> Hi list,
> attached, cvs context diff that adds currval_isset('sequence_name');
> With this patch, I can now call currval_isset to determine if I need to
> call currval. Previously, I just called currval, but with the result of
> filling up the server log with warnings.
This might do what you're looking for on 8.0.
CREATE OR REPLACE FUNCTION currval_isset(text) RETURNS bigint AS '
SELECT currval($1) INTO var;
WHEN OBJECT_NOT_IN_PREREQUISITE_STATE THEN
' LANGUAGE plpgsql;
In response to
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2004-11-07 23:48:08|
|Subject: Re: calling currval() before nextval() patch adding currval_isset() |
|Previous:||From: Peter Eisentraut||Date: 2004-11-07 23:38:14|
|Subject: Re: Romanian translation for 8.0: new file (psql)|