Re: character varying == text?
| От | Alex Turner |
|---|---|
| Тема | Re: character varying == text? |
| Дата | |
| Msg-id | 33c6269f05091910541b93241b@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: character varying == text? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: character varying == text?
|
| Список | 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
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 по дате отправления: