On 21 Feb 2005 at 20:54, Bret Hughes said about "boolean values in postgresql":
> Question: Assuming the above assumption is correct, what is the most
> efficient way to define a column that will take only two values who's
> values will evaluate as intended in php?
How about a CHAR(1) with "Y"/"N" (or "T"/"F") and use a trigger to enforce it.
Or you could
use the small int and have 0/1... the validating trigger's the point...
Mike Morris
The Music Place
1617 Willowhurst Avenue
San Jose, CA 95125
(408) 445-ARTS (2787)
------------------------------------
Your Free Quote:
And that, in my view, is what the whole controversy comes down to:
Are you entitled to the fruits of your own labor, or does government
have some presumptive right to spend and spend and spend?
Ronald Reagan, 1981
------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php