Re: [SQL] Please help, can't figure out what's wrong with this function...

2005-09-12 Thread Tom Lane
Moritz Bayer <[EMAIL PROTECTED]> writes: > I get the following error: > ERROR: missing .. at end of SQL expression > I haven't figured out what this message wants to tell me and why it is > thrown at all. I think it's telling you that you are using a 7.3 or older server. Try 7.4 or later --- plp

Re: [SQL] Please help, can't figure out what's wrong with this function...

2005-09-12 Thread John DeSoi
On Sep 12, 2005, at 8:14 AM, Moritz Bayer wrote: I get the following error: ERROR: missing .. at end of SQL expression it looks like your for loop is being interpreted as the integer variant, e.g. for i in 1..10 loop CREATE TYPE "public"."ty_stadtlandflussentry" AS ( DECLARE objRetu

[SQL] Please help, can't figure out what's wrong with this function...

2005-09-12 Thread Moritz Bayer
Hello group,   I 've written the following function:   CREATE OR REPLACE FUNCTION "public"."getstadtlandflussentrybyid" (integer) RETURNS SETOF "public"."ty_stadtlandflussentry" AS'DECLARE objReturn ty_stadtlandflussentry; DECLARE iid  integer;BEGIN    iid := $1;    for objReturn IN