Ya,
select curval('sequence')
will return the current value, and it is connection specific, in other
words if another connection increments it before you get the value you
will get your value.
Dave
On Wed, 2003-05-07 at 21:20, Hunter Hillegas wrote:
> Does this method exist in any of the pgsql JDBC drivers?
>
> We're testing out some auto-increment stuff for EJBs in JBoss and looking
> for the correct method...
>
> Also, is there a page or doc that details what is and isn't implemented in
> the pg jdbc driver?
>
> Thanks,
> Hunter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Dave Cramer <Dave@micro-automation.net>