Russell Smith writes:
> Really, I can't see how quoting an identifier should change the
> behaviour or resolved type.
REAL is not an identifier. It's a keyword. In fact, it's a reserved
word according to SQL99. So if we were going to do anything about this,
it would be to reject the OP's CREAT
Tom Lane wrote:
> Vincenzo Romano writes:
>
>> I tried this:
>> tmp1=# CREATE DOMAIN real as numeric;
>> [ and got confused between this domain and the built-in "real" ]
>>
>
>
>> It looks like to me this is a bug and also the documentation seems to
>> confirm:
>> "The domain name must
Vincenzo Romano writes:
> I tried this:
> tmp1=# CREATE DOMAIN real as numeric;
> [ and got confused between this domain and the built-in "real" ]
> It looks like to me this is a bug and also the documentation seems to confirm:
> "The domain name must be unique among the types and domains existin
Hi all!
I tried this:
tmp1=# CREATE DOMAIN real as numeric;
CREATE DOMAIN
tmp1=# CREATE TABLE t1 ( r real );
CREATE TABLE
tmp1=# CREATE TABLE t2 ( r "real" );
CREATE TABLE
tmp1=# INSERT INTO t1 VALUES ( 0.01 );
INSERT 0 1
tmp1=# INSERT INTO t1 VALUES (
0.00