again error with pgsql

From: ZioBudda <michel(at)michel(dot)enter(dot)it>
To: pgsql-general(at)postgreSQL(dot)org
Subject: again error with pgsql
Date: 1998-12-10 07:31:49
Message-ID: Pine.LNX.4.03.9812100830590.32541-100000@michel.enter.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"

Browse pgsql-general by date

  From Date Subject
Next Message dustin sallings 1998-12-10 08:21:57 Re: [GENERAL] TODO list elements
Previous Message The Hermit Hacker 1998-12-10 07:10:04 Re: [GENERAL] TODO list elements