Data Types - Mailing list pgsql-general

From Mike Gould
Subject Data Types
Date
Msg-id 20080623180046.152e9104@mail.allcoast.net
Whole thread Raw
Responses Re: Data Types  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-general
We are converting our system from using Sybase's SQL Anywhere 10 to PostGres 8.3.  In SQL Anywhere there technically isn't any difference in how a char and varchar is stored. They are all an array of char[1]. So we always just defined everything as a char since right truncation is the default.

In PostGres though if we are using a character type column to search should we define that as a varchar or a char or does it make any difference?

Best Regards

Michael Gould
Intermodal Software Solutions, LLC.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timezone issue - Is it me or is this a massive bug?
Next
From: Steve Atkins
Date:
Subject: Re: limits?