Postgres Pro
Downloads
Home   >   mailing lists

Re: character varying == text? - Mailing list pgsql-general

From Tom Lane
Subject Re: character varying == text?
Date
Msg-id 16538.1126818466@sss.pgh.pa.us
Whole thread Raw
In response to character varying == text?  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: character varying == text?
List pgsql-general
Tree view 
CSN <cool_screen_name90001@yahoo.com> writes:
> Just something I was curious about - is there any
> difference at all between "character varying" (in the
> SQL spec) without a length specified and "text" (not
> in the SQL spec)?

The SQL standard doesn't allow "character varying" without a length spec.

But yeah, in Postgres they're essentially the same thing.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Asychronous database replication
Next
From: Kevin Murphy
Date:
Subject: Re: CLUSTER equivalent