O Markus Bertheau β^Ψ έγραψε στις Jun 3, 2005 :
> Π? Π?Ρ?Π½, 03/06/2005 Π² 14:20 +0300, Achilleus Mantzios ΠΏΠΈΡ?Π΅Ρ?: > > O Markus Bertheau Ξ²^Ψ ΞΞ³Ο?Ξ±Ο?Ξ΅ Ο?Ο?ΞΉΟ? Jun 3, 2005 : > > > > > Hi, > > > > > > What's the type I need to convert text to before I can convert it to > > > boolean? > > > > just 't' will suffice. > > Well, that's not my question. I have a plpgsql function like that: > > CREATE FUNCTION object_new(class TEXT, properties TEXT[]) > > which I call like > > object_new('Car', ARRAY['color', 'red', 'new', 'true']) > > That means set color to red and new to true. In the function I need to > call > > object_set_boolean_property(object_id INT, property_name TEXT, > property_value BOOLEAN) > > And I can't call it with a TEXT variable, because casting from TEXT to > BOOLEAN isn't possible. Then use the case when ... then ... when ... then ... else ... end construct, e.g. case when mytext='true' then 't'::boolean else 'f'::boolean end Hmm, why dont you leave it as 'true' or 'false' without any castings. > > Markus > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])