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"
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 |