Skip site navigation (1) Skip section navigation (2)

Syntac error

From: Timo Erbach <postgresql(at)netbixx(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Syntac error
Date: 2008-11-25 11:41:32
Message-ID: 492BE46C.8000209@netbixx.com (view raw or flat)
Thread:
Lists: pgsql-general
Hello,

I've defined the following function and get an syntac error whle compiling.
Whats the fault?

CREATE FUNCTION "myscheme"."authenticate" () RETURNS 
"pg_catalog"."refcursor" AS
$body$
DECLARE
    curAccessRights refcursor;

BEGIN
    OPEN curAccessRights FOR
        SELECT * from myscheme."tblUsers";
       
    RETURN curAccessRights;
END;
$body$
LANGUAGE 'sql'

Regards Timo

In response to

Responses

pgsql-general by date

Next:From: A. KretschmerDate: 2008-11-25 11:55:23
Subject: Re: Syntac error
Previous:From: Grzegorz JaśkiewiczDate: 2008-11-25 10:37:47
Subject: two or more pg installations running as the same user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group