Обсуждение: question about meaning of character varying without length

Hello,<br />I've found following description: "If character varying is used without length specifier, the type accepts
stringsof any size. The latter is a PostgreSQL extension."<br /><br />Does this mean that "character varying without
length"is equivalent to "text" type. Are there any differences?<br /><br />I noticed that ODBC driver processes the
typedifferently from "text".<br /><br />Please help!<br />Konstantin<br /><br /><br /> 

On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> Hello,
> I've found following description: "If character varying is used without
> length specifier, the type accepts strings of any size. The latter is a
> PostgreSQL extension."
>
> Does this mean that "character varying without length" is equivalent to
> "text" type. Are there any differences?
>
> I noticed that ODBC driver processes the type differently from "text".
>
> Please help!
> Konstantin

This question would be more appropriate for pgsql-general or maybe
pgsql-odbc, since it is not a question about the development of
PostgreSQL.

character varying and text are different types, but there's no real
difference between them.  I can't speak to what the ODBC driver does.

...Robert

On Tue, Jun 16, 2009 at 12:45 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> I have tried to send to pgsql-general twice, each time it returns error:
> "Relay access denied (state 14)." Will try to post to pgsql-odbc.

Could you provide the full bounce message?

...Robert

Konstantin Izmailov wrote:
> Here you go:
> from    Mail Delivery Subsystem <mailer-daemon@googlemail.com 
> <mailto:mailer-daemon@googlemail.com>>
> to    pgfizm@gmail.com <mailto:pgfizm@gmail.com>
> date    Mon, Jun 15, 2009 at 9:16 PM
> subject    Delivery Status Notification (Failure)
> 
>     
> hide details 9:16 PM (31 minutes ago)
>     
>     
> Reply
>     
>     Follow up message
> 
> This is an automatically generated Delivery Status Notification
> 
> Delivery to the following recipient failed permanently:
> 
>     pgsql-general@postgresql.com <mailto:pgsql-general@postgresql.com>

postgresql.com != postgresql.org...


Stefan

Konstantin Izmailov wrote:
>
>
> Delivery to the following recipient failed permanently:
>
>     pgsql-general@postgresql.com <mailto:pgsql-general@postgresql.com>
>
>

should be pgsql-general@postgresql.org, not pgsql-general@postgresql.com.

cheers

andrew