[GENERAL] Sequences/Problem II.

2001-05-05 Thread Ludwig Meyerhoff
Hallo! I temporary solved the problem with the sequences by making a query: select id from ports order by id desc limit 1; But I am not convinced this is "the real way" to get the number of element the table ports has Saluti! Ludwig ---(end of broadcast)

[GENERAL] Sequences - problem

2001-05-05 Thread Ludwig Meyerhoff
Hallo! I created several tables using a id-sequence for each: create sequence portid; create table ports(id integer primary key default nextval('portid'), name varchar); Now, since it is a web-application I am working on, I have several Perl-scripts acting on/with the database. THe informations