X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 89CD8CD137 for ; Sun, 20 Jul 2003 04:41:43 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 81622-05 for ; Sun, 20 Jul 2003 04:42:18 +0000 (GMT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id EB349CD0FA for ; Sun, 20 Jul 2003 01:41:40 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6K4gIQ3019898; Sun, 20 Jul 2003 00:42:18 -0400 (EDT) To: floyds@4peakstech.com Cc: "Pgsql-Sql" , "Josh Wardle" , "Gregory S. Dodson" Subject: Re: column doesn't get calculated - updated In-reply-to: References: Comments: In-reply-to message dated "Wed, 16 Jul 2003 10:04:39 -0500" Date: Sun, 20 Jul 2003 00:42:17 -0400 Message-ID: <19897.1058676137@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/293 X-Sequence-Number: 14407 writes: > when i copy/paste the select stmt into psql, it works. or if i use it > "dynamically". it doesn't work properly when i use it in a prepared > statement -- which is what i am doing. Could we see a self-contained example of the problem? It's hard to tell whether you are dealing with a bug or pilot error ... regards, tom lane