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 (
Vincenzo Romano vincenzo.rom...@notorand.it 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
Tom Lane wrote:
Vincenzo Romano vincenzo.rom...@notorand.it 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
Russell Smith mr-r...@pws.com.au 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