| From: | josue <josue(at)lamundial(dot)hn> |
|---|---|
| To: | PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Missing numbers |
| Date: | 2005-05-31 14:58:35 |
| Message-ID: | 429C7B9B.1040705@lamundial.hn |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello list,
I need to track down the missing check numbers in a serie, table
contains a column for check numbers and series like this:
dbalm=# select doc_numero,doc_ckseriesfk from bdocs where doc_cta=1
dbalm-# and doc_tipo='CHE' order by doc_numero;
doc_numero | doc_ckseriesfk
------------+----------------
19200 | 856938
19201 | 856938
19215 | 856938
19216 | 856938
19219 | 856938
Missing numbers are:
from 19202 to 19214 and 19217,19218
Does anyone knows a way to get that done in SQL or plpgsql, thanks in
advance
--
Sinceramente,
Josué Maldonado.
... "De hecho el paso de compilación a objeto suele atravesar una fase
intermedia en que se genera un fichero en lenguaje ensamblador y se
invoca al programa ensamblador del sistema." -- Tutorial de C
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-05-31 15:18:29 | Re: Accessing PostgreSQL from C++ |
| Previous Message | Rafa Couto | 2005-05-31 14:36:50 | Re: pg_get_serial_sequence and table inheritence |