Re: How to convert SQL store procedure to Postgresql function

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to convert SQL store procedure to Postgresql function
Date: 2012-02-28 12:22:56
Message-ID: 201202281322.56490.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Klingler 2012-02-28 12:38:35 Re: Natural sort order
Previous Message Rehan Saleem 2012-02-28 12:00:02 Re: How to convert SQL store procedure to Postgresql function