I am getting an “invalid input syntax for type double precision” error when I return an array as part of a composite type from my C-language function. I can re-create this situation with just a type and a function. My type is declared as follows: CREATE TYPE my_grid AS (min_x double precision, min_y double precision, max_x double precision, max_y double precision, my_arr double precision[][]); My function is defined as: CREATE FUNCTION my_test() RETURNS void AS $$ DECLARE mine my_grid; BEGIN SELECT INTO mine (0.1, 0.2, 0.3, 0.4,'{{88.9}}'::double precision[][])::my_grid; END $$ LANGUAGE plpgsql SECURITY DEFINER SET search_path = public; To get the error, I run the following query: SELECT MY_TEST(); If I do a plain “SELECT (0.1, 0.2, 0.3, 0.4,'{{88.9}}'::double precision[][])::my_grid;” everything looks good. Any help would be appreciated. NOTICE: This message is covered by the Electronic Communications Privacy Act, Title 18, United States Code, Sections 2510-2521. This e-mail and any attached files are the exclusive property of Pictometry International Corp., are deemed privileged and confidential, and are intended solely for the use of the individual(s) or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or believe that you have received this message in error, please delete this e-mail and any attachments and notify the sender immediately. Any other use, re-creation, dissemination, forwarding or copying of this e-mail is strictly prohibited and may be unlawful. |
