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

From Alex Turner
Subject Re: character varying == text?
Date
Msg-id 33c6269f05091910541b93241b@mail.gmail.com
Whole thread Raw
In response to Re: character varying == text?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: character varying == text?
List pgsql-general
I thought a char field was supposed to return a padded string, and varchar was supposed to return a non-padded string?

I just checked though:

create table test (
stuff char(10)
);

insert into test values ('foo');

select stuff || 'lemon' from test;

This returns 'foolemon', not 'foo        lemon' as I would have expected.

Alex Turner
NetEconomist

On 9/15/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Help trying to write my first plpgsql function...
Next
From: Alex Turner
Date:
Subject: Re: Arrrr... date formatting.