Subject: Re: convert_numeric_to_scalar: unsupported type 354210
From: Rod Taylor <rbt@rbt.ca>
To: AgentM <agentm@cmu.edu>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <1BDD614C-A552-11D7-A47E-0030657192DA@cmu.edu>
References: <1BDD614C-A552-11D7-A47E-0030657192DA@cmu.edu>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-JSNIJeNzFRcqZNqYedkc"
Message-Id: <1056376831.63013.15.camel@jester>
Mime-Version: 1.0
Date: 23 Jun 2003 10:00:32 -0400

--=-JSNIJeNzFRcqZNqYedkc
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> select id from data where dec < 2.0;
> ERROR:  convert_numeric_to_scalar: unsupported type 354210

Domains exposed (and introduced) a number of interesting issues in
regards to type switching for these things.

Cast the 2.0 value to the domain:
	CAST(2.0 AS physreal)

or quote it and let the system figure it out:
	dec < '2.0'


Simply put, without quotes the parser assumes that 2.0 is a numeric,
which doesn't have a direct < operator for use with the domain.

Another alternative would be to create a new < operator, but thats more
work than it's worth.

This has been fixed for 7.4 (the system implicitly coerces the domain to
numeric for the index comparison).
--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-JSNIJeNzFRcqZNqYedkc
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA+9wf/6DETLow6vwwRArrhAJ98UD+lF+jq8um+vyIYeAn0DdTH2ACfY+WQ
iv5x+nDtF1g9p5wuuhPVcC0=
=L7qZ
-----END PGP SIGNATURE-----

--=-JSNIJeNzFRcqZNqYedkc--