Re: User-defined typle similar to char(length) varchar(length)

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: User-defined typle similar to char(length) varchar(length)
Date: 2006-08-01 13:27:27
Message-ID: 44CF56BF.9070003@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> char(42) 'literal value here'
>

Playing around that I noticed:

postgres=# select '{asd}'::text[], '{asd}'::_text, _text '{asd}';
text | _text | _text
-------+-------+-------
{asd} | {asd} | {asd}
(1 row)

postgres=# select text[] '{asd}';
ERROR: syntax error at or near "]"
LINE 1: select text[] '{asd}';

Is it desired effect?

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-01 13:29:48 Re: User-defined typle similar to char(length) varchar(length)
Previous Message Bruce Momjian 2006-08-01 13:20:03 Re: Online index builds