pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Oleg Lebedev <olebedev@waterford.org>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Quotes and spaces
Date: Fri, 05 Oct 2001 17:54:11 -0600
Message-ID: <3BBE4822.B69C2B0E@waterford.org> (raw)
References: <Pine.BSF.4.21.0110051630090.63466-100000@megazone23.bigpanda.com>
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');
view thread (4+ messages)
Message-ID: <3BBE4822.B69C2B0E@waterford.org> Permalink: ../3BBE4822.B69C2B0E@waterford.org/ Also on: postgresql.org/message-id/3BBE4822.B69C2B0E@waterford.org ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: olebedev@waterford.org, sszabo@megazone23.bigpanda.com Subject: Re: Quotes and spaces In-Reply-To: <3BBE4822.B69C2B0E@waterford.org> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox