Re: Chante domain type - Postgres 9.2 - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Chante domain type - Postgres 9.2
Date
Msg-id nsb9ao$fur$1@blaine.gmane.org
Whole thread Raw
In response to Re: Chante domain type - Postgres 9.2  (Rakesh Kumar <rakeshkumar464@outlook.com>)
Responses Re: Chante domain type - Postgres 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Rakesh Kumar schrieb am 26.09.2016 um 15:08:
>>You sound like you think that varchar(50) is somehow cheaper than text.
>
> The biggest impediment to text cols in other RDBMS  is no index allowed.
> If PG has an elegant solution to that, then yes I see the point made by the
> original poster.

Don't confuse Postgres' "text" data type with "text" in other DBMS.

There is no difference whatsoever between varchar and text in Postgres.





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats update difference between VACUUM ANALYZE and ANALYZE in 9.2?
Next
From: Adrian Klaver
Date:
Subject: Re: Chante domain type - Postgres 9.2