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/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql