В Птн, 03/06/2005 в 14:45 +0300, Achilleus Mantzios пишет:
> Then use the
> case when ... then ... when ... then ... else ... end
> construct, e.g.
> case when mytext='true' then 't'::boolean else 'f'::boolean end
Because I don't want to reimplement postgres' boolean parsing.
> Hmm, why dont you leave it as 'true' or 'false' without any castings.
Because then pg doesn't find the function because it looks for one with
a text argument.
Markus
--
Markus Bertheau ☭ <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
