Re: How to convert SQL store procedure to Postgresql function - Mailing list pgsql-sql

From Leif Biberg Kristensen
Subject Re: How to convert SQL store procedure to Postgresql function
Date
Msg-id 201202281322.56490.leif@solumslekt.org
Whole thread Raw
In response to Re: How to convert SQL store procedure to Postgresql function  (Rehan Saleem <pk_rehan@yahoo.com>)
List pgsql-sql
 Tirsdag 28. februar 2012 12.56.46 skrev Rehan Saleem :
> hi ,
> whats wrong with this function , i am getting syntax error which is syntax
> error at or near "+=" LINE 13:  set sql += ' bpoverlap, centredistance

You can't concatenate that way in plpgsql. Instead of "set sql +=" try with 
just "||" which is the operator joining two strings.

regards, Leif
http://code.google.com/p/yggdrasil-genealogy/


pgsql-sql by date:

Previous
From: Rehan Saleem
Date:
Subject: Re: How to convert SQL store procedure to Postgresql function
Next
From: Richard Klingler
Date:
Subject: Re: Natural sort order