Error $1 Is Declared Constant
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News ERROR: $1 is declared CONSTANT in plpgsql From: Hans Plum
search in one of my setsExclude this search from one of my sets 5 messages in org.postgresql.pgsql-noviceRe: ERROR: $1 is declared CONSTANT in...FromSent OnAttachmentsHans PlumMay 7, 2002 4:18 https://www.postgresql.org/message-id/3CD7B810.7000009@giub.uni-bonn.de am Jason DavisMay 7, 2002 7:08 am Tom LaneMay 7, 2002 7:40 am Oliver ElphickMay 7, 2002 7:50 am Henshall, Stuart - WCPMay 7, 2002 9:13 am Subject:Re: ERROR: $1 is declared CONSTANT in plpgsql From:Tom Lane (tg...@sss.pgh.pa.us)Date:May http://markmail.org/message/ymtr22a4ilvkkzeh 7, 2002 7:40:31 amList:org.postgresql.pgsql-noviceHans Plum
try to convert Ascii-Strings in HTML-conform Strings (Converting '?quator' -> 'Äquator') ... Now I get a error message like this: NOTICE: plpgsql: ERROR during compile of f_ascii2html near line 7 ERROR: $1 is declared CONSTANT For me $1, or better InpAscii is not CONSTANT ... I cannot find the mistake ... Can anybody help out? Hopefully, you can reproduce the error with the code right here. Thanks a lot, Hans PS: There is some debug-code that I have not used http://www.verycomputer.com/102_de1f0ea71a821f29_1.htm because the functions does not work ;-)). -- BEGIN OF SKRIPT ... DROP TABLE t_ascii2html; /* table for replacing letters */ CREATE TABLE t_ascii2html ( ascii VARCHAR(1), html VARCHAR(20) ); INSERT INTO t_ascii2html VALUES ('?','ä'); INSERT INTO t_ascii2html VALUES ('?','ö'); INSERT INTO t_ascii2html VALUES ('','ü'); INSERT INTO t_ascii2html VALUES ('?','ä'); INSERT https://books.google.com/books?id=74rPV1kfBF4C&pg=PA324&lpg=PA324&dq=error+$1+is+declared+constant&source=bl&ots=Y0KHn5FoGK&sig=klFOEn7wjThM-8RYzaPz4qC8Zc8&hl=en&sa=X&ved=0ahUKEwjn5NK108PPAhUCwWMKHbTDDHUQ6AEIVzAJ INTO t_ascii2html VALUES ('?','ö'); INSERT INTO t_ascii2html VALUES ('','ü'); INSERT INTO t_ascii2html VALUES ('?','ß'); INSERT INTO t_ascii2html VALUES ('"','"'); INSERT INTO t_ascii2html VALUES ('&','&'); INSERT INTO t_ascii2html VALUES ('<','<'); INSERT INTO t_ascii2html VALUES ('>','>'); DROP FUNCTION f_ascii2html(TEXT); /* Converting 'special' letters (eg. german umlaute like "?") into a HTML-conform string */ CREATE FUNCTION f_ascii2html(TEXT) error $1 RETURNS TEXT AS ' DECLARE InpAscii ALIAS FOR $1; CharMap RECORD; InsertPosition INTEGER; Part1 TEXT; Part2 TEXT; BEGIN InpAscii := $1; -- Select all datasets from the table describing the replacement error $1 is FOR CharMap IN SELECT * FROM f_ascii2html LOOP RAISE NOTICE ''CharMap --- ASCII: %, HTML: %'', t_ascii2html.ascii, t_ascii2html.html; WHILE InpAscii ~ CharMap.ascii RAISE NOTICE ''INPASCII: %'', InpAscii; SELECT position(InpAscii IN CharMap.ascii) INTO InsertPosition; RAISE NOTICE ''INSERTPOSITION: %'', InsertPosition; SELECT substrg(InpAscii FROM (InsertPosition - 1)) INTO Part1; RAISE NOTICE ''PART1: %'', Part1; SELECT substrg(InpAscii FROM (InsertPosition + 1)) INTO Part2; RAISE NOTICE ''PART2: %'', Part2; InpAscii := Part1 || CharMap.html || Part2 ; RAISE NOTICE ''IN
von GoogleAnmeldenAusgeblendete FelderBooksbooks.google.de - Sams¿ PHP and MySQL Web Development, by Luke Welling and Laura Thomson, showed that there is a strong demand for books that describe how to use PHP together with a specific open-source database to develop Web applications. While MySQL is very popular, PostgreSQL is widely considered to be the more powerful...https://books.google.de/books/about/PHP_and_PostgreSQL.html?hl=de&id=74rPV1kfBF4C&utm_source=gb-gplus-sharePHP and PostgreSQLMeine BücherHilfeErweiterte BuchsucheDruckversionKein E-Book verfügbarSams PublishingAmazon.deBuch.deBuchkatalog.deLibri.deWeltbild.deIn Bücherei suchenAlle Händler»Stöbere bei Google Play nach Büchern.Stöbere im größten eBookstore der Welt und lies noch heute im Web, auf deinem Tablet, Telefon oder E-Reader.Weiter zu Google Play »PHP and PostgreSQL: Advanced Web ProgrammingEwald Geschwinde, Hans-Jürgen SchönigSams Publishing, 2002 - 772 Seiten 0 Rezensionenhttps://books.google.de/books/about/PHP_and_PostgreSQL.html?hl=de&id=74rPV1kfBF4CSams¿ PHP and MySQL Web Development, by Luke Welling and Laura Thomson, showed that there is a strong demand for books that describe how to use PHP together with a specific open-source database to develop Web applications. While MySQL is very popular, PostgreSQL is widely considered to be the more powerful of the two open-source databases. And PostgreSQL is rapidly gaining market share large organizations are beginning to use PostgreSQL instead of Oracle; the demand for PostgreSQL training and support has increased by some accounts 50% in the last six months; and Web hosting services increasingly offer PostgreSQL along with MySQL. PHP and PostgreSQL Advanced Web Programming focuses on the specific needs of a PostgreSQL developer and will detail how to make use of PostgreSQL¿s unique, advanced features to develop high-availability, fail-safe Web applications with PHP and PostgreSQL. Voransicht des Buches » Was andere dazu sagen-Rezension schreibenEs wurden keine Rezensionen gefunden.Ausgewählte SeitenTitelseiteInhaltsverzeichnisIndexInhaltII5 III6 IV7 V11 VI14 VII15 IX16 X38 LXXVI358 LXXVII363 LXXVIII375 LXXIX378 LXXX379 LXXXI381 LXXXII385 LXXXIII392 MehrXI39