Quotes and spaces
От | Oleg Lebedev |
---|---|
Тема | Quotes and spaces |
Дата | |
Msg-id | 3BBE340A.B8788CAE@waterford.org обсуждение исходный текст |
Ответ на | Re: Why the weak key is created as unique (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: Quotes and spaces
Re: Quotes and spaces |
Список | pgsql-sql |
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? thanks, Oleg
В списке pgsql-sql по дате отправления: