Re: Error - Mailing list pgsql-novice

From Marcus Engene
Subject Re: Error
Date
Msg-id 438F3F8F.3030006@engene.se
Whole thread Raw
In response to Re: Error  (<operationsengineer1@yahoo.com>)
List pgsql-novice
> it says...
>
> ERROR: relation "t_customer_cust_id_seq" does not
> exist
>
> i'm off to hunt down the actual name of the sequence.
>
> bottom line - if you get a boolean response, check to
> see if the query has failed first.
>
> thank you for the insight.

Quite a few functions in php do this. If you use the
syntax == or != it is C-style compare. That is, zero
is false and basically the rest is true.

If you use === or !== it evaluates to true if both
the types are equal AND the statement is true.

So, the correct syntax would be

if (false === ($customer_id = $db->getone("..."))) {
     error handling.
}

Example from the manual:
// in PHP 4.0b3 and newer:
$pos = strrpos($mystring, "b");
if ($pos === false) { // note: three equal signs
     // not found...
}

By doing this, strrpos can return 0 (not an error) or
false (not found). Without === strrpos would have to
return -1 or some other illegal position for not found.

Best regards,
Marcus

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Error
Next
From: ig@freemail.gr (ILIAS GOUDAROPOULOS)
Date:
Subject: Re: PostgreSQL 8.1.0-2 WinXP Services