> This might do what you're looking for on 8.0.
>
> CREATE OR REPLACE FUNCTION currval_isset(text) RETURNS bigint AS '
> DECLARE
> var integer;
> BEGIN
> SELECT currval($1) INTO var;
>
> RETURN var;
>
> EXCEPTION
> WHEN OBJECT_NOT_IN_PREREQUISITE_STATE THEN
> RETURN 0;
> END;
> ' LANGUAGE plpgsql;
>
> SELECT isset('tst_seq');
>
k, i don't actually have an 8.0 installation to play with here,. but
won't this still produce a warning?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
