Received: from webcon.net (guru.webcon.net [216.187.106.140]) by postgresql.org (Postfix) with ESMTP id 5B7AD475B51 for ; Thu, 25 Apr 2002 01:44:20 -0400 (EDT) Received: from light.int.webcon.net (light.int.webcon.net [192.168.1.1]) by webcon.net (8.11.6/8.11.6) with ESMTP id g3P5iOS23294 for ; Thu, 25 Apr 2002 01:44:24 -0400 Date: Thu, 25 Apr 2002 01:44:15 -0400 (EDT) From: Ian Morgan To: pgsql-sql@postgresql.org Subject: SELECT in a function != SELECT ? In-Reply-To: <200204250441.AAA23640@io.hypernet.com.py> Message-ID: Organization: "Webcon, Inc." MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/292 X-Sequence-Number: 7556 While trying to formulate an answer to another user's query on this list, I came a across what I think is strange behaviour in an SQL funsction: The 3rd column of my 'contacts' table is 'first_name'. A regular select will allow me to find this: SELECT a.attname FROM pg_class c, pg_attribute a WHERE c.relname = 'contacts' and a.attnum = 3 and a.attrelid=c.oid; attname ------------ first_name (1 row) But when turned into a function: CREATE FUNCTION get_colname (name,smallint) RETURNS name AS ' SELECT a.attname FROM pg_class c, pg_attribute a WHERE c.relname = ''$1'' and a.attnum = $2 and a.attrelid=c.oid ' LANGUAGE SQL; SELECT get_colname('contacts',3); get_colname ------------- (1 row) The result is empty!? Even more strange: SELECT 'x'||get_colname('contacts',3)||'x' as foo; foo ----- (1 row) Should I not be seeing "xx" as the result here!? What's going on? Anyone wknow why the above function get_colname isn't doing what I expect? Regards, Ian Morgan -- ------------------------------------------------------------------- Ian E. Morgan Vice President & C.O.O. Webcon, Inc. imorgan@webcon.net PGP: #2DA40D07 www.webcon.net * Customized Linux network solutions for your business * -------------------------------------------------------------------