When using "IDENTITY" as my primary key, I can select the last inserted ID with
SELECT LAST_IDENTITY() FROM %TSQL_sys.snf;
Actually this is how Hibernate + Iris' Driver acquires the inserted ID when mapping with
@GeneratedValue(strategy = GenerationType.IDENTITY)
Now, considering that I am using the type "SERIAL" as my primary key instead, how can I get the last inserted ID?
Note that with "SERIAL" I can forcefully insert any value for this ID, from which Iris will continue generating values...