Re: [GENERAL] Recursive CTE in function problem

ugh, simple syntax screw up. Thanks David. On 02/04/2016 02:45 PM, David G. Johnston wrote: On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle >wrote: But when I use it as a function it always returns false: CREATE OR REPLACE FUNCTION grpl_collection.copy_in_collect

Re: [GENERAL] Recursive CTE in function problem

On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle wrote: > But when I use it as a function it always returns false: > > CREATE OR REPLACE FUNCTION grpl_collection.copy_in_collection_name(cpid > bigint, colname text) > RETURNS boolean > LANGUAGE plpgsql > AS $function$ > BEGIN > RETURN cpid in (sel