Yeah, I guess so. I just didn't want the compiler to think I was
trying to assign the value. And I also figured out that instead of
the &&, I needed to just say AND Thanks.
Ferindo
John DeSoi wrote:
On Aug 6, 2005, at 10:52 PM, Ferindo Middleton Jr wrote:
ERROR: operator does
On Aug 6, 2005, at 10:52 PM, Ferindo Middleton Jr wrote:
ERROR: operator does not exist: boolean == boolean
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
CONTEXT: SQL statement "SELECT (( $1 == true) && ( $2 == true))"
PL/pgSQL
I'm trying to write a function and trigger to validate that user data
entry for boolean values makes sense before being inserted or updated
into my database. I have the following trigger:
CREATE TRIGGER trigger_registration_and_attendance
BEFORE INSERT OR UPDATE
ON registration_and_attendance
F
Hi,
what encoding do your webpages have, and what encoding does your database have?
If both have the same encoding (eg both UTF8 or both Latin1), all should go
well, otherwise you will have to adapt encodings before putting form data into
the database (and vice versa), eg with utf_encode / utf_
Hello,
This is probably a character encoding issue ; try issuing a SET
client_encoding TO whatever encoding you're using ; it is possible that
your connection through PHP defaults to SQL_ASCII in which "é" is illegal
(mine did). Or, check your browser, form etc. encoding to make s
Hello,
I compiled Postgresql 8 on my server and installed it
I am trying to insert a string using php and PEAR::DB
The string contain: é and this cause
$db-query to fail with an Unkown error as error message.
If i insert the data using pgAdminIII the string is inserted into the
table.
I don
On Sat, 2005-08-06 at 05:00 +, wisan watcharinporn wrote:
> how can i use
>
> create table myName(
>myColumnName varchar(32)
> );
>
> select myColumnName from myColumnName ;
Assuming you meant 'from myName' here,
this should work.
On the other hand, this will NOT work:
create table "
