Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f56CAaE85432 for ; Wed, 6 Jun 2001 08:10:36 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smartt.com (ktk6.smartt.com [209.52.5.253]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f530QTE00264 for ; Sat, 2 Jun 2001 20:26:30 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: from nomad.localdomain (alpnb13234.smarttadsl.com [209.52.13.234]) by smartt.com (8.11.1/8.11.1) with SMTP id f530b7c00990 for ; Sat, 2 Jun 2001 17:37:07 -0700 (PDT) Message-Id: <200106030037.f530b7c00990@smartt.com> Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit Mime-Version: 1.0 From: "Clayton Cottingham aka drfrog" To: PostgreSQL SQL List Subject: help with a function X-Mailer: Pronto v2.2.5 On linux/Pg Date: 02 Jun 2001 17:27:30 PDT Reply-To: "Clayton Cottingham aka drfrog" In-Reply-To: References: X-Archive-Number: 200106/57 X-Sequence-Number: 3269 consider this function: CREATE FUNCTION "test" (integer) RETURNS text AS 'return "select * from testt limit $_[o];";' LANGUAGE 'plperl'; how would i get it to just run the query instead of just return it as text using plperl?