Get nextvalue of sequence in postgresql

Question

I would like to get nextvalue of sequence in postgresql in my controller.

I wrote a Custom Query, but I need to set it as Id (which is integer type).

How can I do that or I should write custom insert query too?

int count = session.CreateSQLQuery("SELECT nextval('transport_id_seq')");

@dude: `select max(..)` won't work in a multi-user environment. Using `max()` to generate ids either does not work or won't scale for more than a single transaction. Using a sequence is the only way to generate unique ids — , Aug 14 '14 at 11:59
Ya.. Thats why I'm trying to select nextval and do transaction in one Function. Because I need multi-user environment. — Justina Seliokaite, Aug 14 '14 at 12:06
It's type mismatch. my query is NHIBernate.ISQLQuery type and count is int type.. — Justina Seliokaite, Aug 14 '14 at 12:15
@JustinaSeliokaite You have to *execute* the query. You can't just assign it to a variable. — Craig Ringer, Aug 14 '14 at 15:20

score 4 · Accepted Answer · answered Aug 15 '14 at 00:20

4

As @Craig Ringer says, just execute the query:

var count = session.CreateSQLQuery("SELECT nextval('transport_id_seq')")
    .UniqueResult<long>();

answered Aug 15 '14 at 00:20

Najera

And how can I get Integer value, not long? – Justina Seliokaite Aug 19 '14 at 06:55

1 Answers1