× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2017-02-06T22:51:32Z  · raghavsingh last modified 2017-02-08T06:00:38Z

Postresql -> Function with array fails to compile in function editor


Priority Critical
Complexity Unknown
Component DB - PostgreSQL
Version 17.0

  If we create a function in postgresql with an array type the function is created successfully.  When we attempt to use the edit in function editor gui, the compile returns : [Function with this signature does not exist.]

Below is DDL example: 

CREATE FUNCTION "public"."foo" (in bar integer[]) RETURNS TABLE (unrolled integer) AS
    $quote$
        BEGIN
            RETURN QUERY SELECT unnest(bar) AS unrolled;
        END;
    $quote$
    LANGUAGE 'plpgsql'
1 attachment

Issue #14992

Closed
Fixed
Resolved 2017-02-07T21:05:42Z
 
 
Completion
No due date
Fixed Build v17.0.11-8
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017