Re: Inserting data of two other tables [Now deleting ...]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nabil Sayegh wrote:

| please send us the output of all involved tables with \d

Here they are:
| Table "captrajectes"
| Column | Type | Modifiers
| ------------+---------------+-----------
| traye | numeric(5,0) |
| linea | numeric(4,0) |
| filler | character(4) |
| n-bill-in | numeric(9,0) |
| n-bill-fi | numeric(9,0) |
| n-bono-in | numeric(9,0) |
| n-bono-fi | numeric(9,0) |
| c-bono-in | numeric(9,0) |
| c-bono-fi | numeric(9,0) |
| turno | numeric(4,0) |
| condu | numeric(4,0) |
| horahora | numeric(2,0) |
| horamin | numeric(2,0) |
| horafihora | numeric(2,0) |
| horafimin | numeric(2,0) |
| fecha | numeric(8,0) | not null
| maquina | numeric(6,0) |
| bus | numeric(4,0) |
| billenet | numeric(5,0) |
| euronet | numeric(7,2) |
| eurovalor | numeric(7,2) |
| pkey | character(10) | not null
| trec | numeric(6,0) |
| Primary key: pkey_fecha
|
| Table "detalltrajectes"
| Column | Type | Modifiers
| ------------+---------------+-----------
| nserie | numeric(9,0) |
| nseriechip | numeric(10,0) |
| tipotrbus | numeric(2,0) |
| paraor | numeric(4,0) |
| parade | numeric(4,0) |
| hora1hora | numeric(2,0) |
| hora1min | numeric(2,0) |
| pasaindi | numeric(2,0) |
| numvez | character(2) |
| clase | numeric(4,0) |
| tarifa | numeric(4,0) |
| tarneto | numeric(8,2) |
| tarbruto | numeric(8,2) |
| formapago | numeric(1,0) |
| texto | character(1) |
| journey | character(10) |
| salreca | numeric(9,2) |

Josep Sànchez
~ [papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+1L7R2vx52x0kyz4RArzkAKCG5pYRrHRQ/MCTekngl5R97oWCpQCfblzv
L/yMj/OHn00+unppRMFAggk=
=Cqjl
-----END PGP SIGNATURE-----