am Fri, dem 14.03.2008, um 10:00:05 -0700 mailte Webb Sprague folgendes: > Hi all, > > I have the following function: > > create function new_student (text) returns text as $$ > declare > wtf integer := 1; > begin > execute 'create schema ' || $1; > execute 'create role ' || $1 || 'LOGIN';
Assume, $1 contains 'foobar', you create role 'foobarlogin' now. Insert a space before 'LOGIN' -> ' LOGIN'. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
