Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f95NZjn60560 for ; Fri, 5 Oct 2001 19:35:45 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 386; Fri, 5 Oct 2001 17:26:05 -0600 Message-ID: <3BBE4822.B69C2B0E@waterford.org> Date: Fri, 05 Oct 2001 17:54:11 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo CC: pgsql-sql@postgresql.org Subject: Re: Quotes and spaces References: Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/100 X-Sequence-Number: 5055 I just upgraded to 7.1 and the query works for me now. thanks, Oleg Stephan Szabo wrote: > On Fri, 5 Oct 2001, Oleg Lebedev wrote: > > > Hi, > > I looked through PL/pgSQL tutorial, but I can't get quotes and spaces to > > work in queries executed from Pl/pgSQl. Here is an example: > > > > create procedure get_name(varchar) > > ... > > BEGIN > > query := ''SELECT first_name || '''' '''' || last_name FROM user''; > > EXECUTE query; > > ... > > END; > > ... > > > > Basically I want to get full name, i.e. first name separated with space from > > the last name. If I follow the PL/pgSQL manual as shown above, I get parse > > error. > > What am I doing wrong? > > Odd, a script like the following works for me on both 7.1 and 7.2devel: > > drop table aa; > drop function fgn(varchar); > create table aa(a varchar); > insert into aa values ('d'); > create function fgn(varchar) returns text as ' > DECLARE > query text; > rec record; > BEGIN > query := ''SELECT a || '''' '''' || a as bar from aa;''; > RAISE NOTICE ''%'', query; > FOR rec in EXECUTE query LOOP > return rec.bar; > END LOOP; > END;' > language 'plpgsql'; > select fgn('f');