again error with pgsql
От | ZioBudda |
---|---|
Тема | again error with pgsql |
Дата | |
Msg-id | Pine.LNX.4.03.9812100830590.32541-100000@michel.enter.it обсуждение исходный текст |
Список | pgsql-general |
Hi, I have this query : select libro.id_libro, libro.collocazione, libro.titolo from prestito, libro where prestito.id_libro = libro.id_libro_key and prestito.visto = false if I run it from "psql my_db_name" I get esame=> select libro.id_libro, libro.collocazione, libro.titolo from esame-> prestito, libro where prestito.id_libro = libro.id_libro_key and prestito.visto = false\g id_libro|collocazione|titolo --------+------------+-------------------------- k1 |d2 |Il talismano f4 |s1 |Va' dove ti manda il cuore (2 rows) and it is ok. but If I run it from a php/page i get: Warning: PostgresSQL query failed: ERROR: using an explicit cast why this ? I have posted here, because in the php3-ML there is no response.. I don't know if it is a pgsql error or a php3 error. "Il divertimento e' giusto se la scimmia ci prende gusto" -- Italian Linux Press: http://ziobudda.enter.it/ILP/ -- Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group michel@michel.enter.it - http://ziobudda.enter.it/ Linux Problem? Ask to linux@media.dsi.unimi.it "/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"
В списке pgsql-general по дате отправления: