[GENERAL] How can I get the last serial I inserted?

Dear all, I would like to insert a row into a table with serial type id as other table's reference key. After that insert, I would use the inserted serial to insert into another table. The problem is how can I find that serial value and ensuring other is inserting at the same time? Best r

[GENERAL] Database Diagram Drawing Tools ?

Dear all, I need drawing tools to show the table relationship. I have used pgaccess but it seems that the effect is not very good. Are there any recommendations? Best regards, Boris

Re: [GENERAL] Database Diagram Drawing Tools ?

Hi all, I have downloaded the dia 0.80 for Redhat. But it has only diagrams for flowchart, network, sybase uml and circuit. I would like to use it to show the table fields and the relationship. How can I do it? Many thanks!!! Best regards, Boris Quoting Karl DeBisschop <[EMAIL PROTECTED]>:

[GENERAL] select question

Dear all, Is there a way I can select the top 50 rows from table, 51 - 100 rows from table etc (with order clause)? It is because I am writing a message board and I would like to create the prev/next button on different page. Many thanks. Best regards, Boris

[GENERAL] hierarchy select question?

Dear all, I would like to define threads in message system for replies to message but if I define too many level, I am afraid I have problem in the select... Say, I have define 3 levels: 1 / \ 2 3 /\\ 4 5 6 It means message 2 is a reply to 1. 4 is a furt

[GENERAL] SQL Manager 2007 for PostgreSQL released

We, here at EMS Database Management Solutions, are pleased to announce SQL Manager 2007 for PostgreSQL - the new major version of the powerful PostgreSQL administration and development tool! You can download SQL Manager 2007 for PostgreSQL at: http://www.sqlmanager.net/products/postgresql/manager