Concatenating

From: Juan Francisco Diaz <j-diaz(at)publicar(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Concatenating
Date: 2003-09-23 22:08:38
Message-ID: BB962E96.B19%j-diaz@publicar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, i have this:

cadena := 'select * from orden where idlibro = ';
cadena := cadena || Libro;
cadena := cadena || ' order by idorden limit ';
cadena := cadena || ''numFin'';
cadena := cadena || ';';

And I cant get it to wrok. Libro and numFin are variables that are received
in a pgsql function. Libro is char(6) and numFin is numeric.
I tried this and also doing everything in the same line... With no good
results... Iam now very confused with this!!!! AHAHHAHAh
Any helpgratly appreciated.

JuanF
"a newbie with quotes in his head"

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Heath Tanner 2003-09-24 02:03:23 Re: Concatenating
Previous Message Joe Conway 2003-09-23 15:11:53 Re: Is there an equivalent in plpgsql of Oracle's DBMS_OUTPUT.PUT_LINE?