X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 06366D1C9D7 for ; Fri, 19 Mar 2004 15:27:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43604-07 for ; Fri, 19 Mar 2004 11:27:19 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 4844BD1EBB6 for ; Fri, 19 Mar 2004 11:27:05 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2JFPqqY024381; Fri, 19 Mar 2004 10:25:52 -0500 (EST) To: "Thomas Leung" Cc: pgsql-admin@postgresql.org Subject: Re: create function problem In-reply-to: References: Comments: In-reply-to "Thomas Leung" message dated "Tue, 16 Mar 2004 12:02:24 +0800" Date: Fri, 19 Mar 2004 10:25:52 -0500 Message-ID: <24380.1079709952@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/262 X-Sequence-Number: 12831 "Thomas Leung" writes: > str := to_char($1, "YYYY"); > ERROR: Attribute "YYYY" not found Double and single quotes are not interchangeable. Here you have written an identifier, not a string literal. You'll need str := to_char($1, ''YYYY''); or str := to_char($1, \'YYYY\'); according to taste. regards, tom lane