[SQL] Boolean output representation.

[Dmitriy Igrishin]

Hey all,

As is known, there are many valid literal values for the "true"
and "false" state of boolean data type.
True whether that output of boolean type shows only using
the letters 't' and 'f' or its possible to change the output representation,
e.g., to "true" or "false" ("1", "0")?

Regards,
Dmitriy

Re: [SQL] Boolean output representation.

[Pavel Stehule]

Hello

2010/8/26 Dmitriy Igrishin :
> Hey all,
>
> As is known, there are many valid literal values for the "true"
> and "false" state of boolean data type.
> True whether that output of boolean type shows only using
> the letters 't' and 'f' or its possible to change the output representation,
> e.g., to "true" or "false" ("1", "0")?
>

no, it isn't possible - you can write a simple formating function or
own custom data type.

Regards

Pavel Stehule

> Regards,
> Dmitriy
>
>

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Boolean output representation.

[Dmitriy Igrishin]

Hey Pavel,

Thanks for you answer !
And many thanks to developers because my task a bit simplified
because of that :)

Regards,
Dmitriy

2010/8/26 Pavel Stehule 

> Hello
>
> 2010/8/26 Dmitriy Igrishin :
> > Hey all,
> >
> > As is known, there are many valid literal values for the "true"
> > and "false" state of boolean data type.
> > True whether that output of boolean type shows only using
> > the letters 't' and 'f' or its possible to change the output
> representation,
> > e.g., to "true" or "false" ("1", "0")?
> >
>
> no, it isn't possible - you can write a simple formating function or
> own custom data type.
>
> Regards
>
> Pavel Stehule
>
> > Regards,
> > Dmitriy
> >
> >
>