Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0B39D475E8C
	for <pgsql-sql@postgresql.org>; Sun, 26 Jan 2003 03:06:46 -0500 (EST)
Received: from localhost.localdomain (unknown [216.31.142.3])
	by postgresql.org (Postfix) with ESMTP id 1AF0E475E4D
	for <pgsql-sql@postgresql.org>; Sun, 26 Jan 2003 03:06:45 -0500 (EST)
Received: from larubber.com (server [127.0.0.1])
	by localhost.localdomain (8.11.6/8.11.6) with SMTP id h0Q8f0P09127
	for <pgsql-sql@postgresql.org>; Sun, 26 Jan 2003 00:41:00 -0800
Received: from 216.86.192.34 (SquirrelMail authenticated user ddurst)
	by www.la-rubber.com with HTTP; Sun, 26 Jan 2003 00:41:00 -0800 (PST)
Message-ID: <44933.216.86.192.34.1043570460.squirrel@www.la-rubber.com>
Date: Sun, 26 Jan 2003 00:41:00 -0800 (PST)
Subject: ERROR:  Cannot display a value of type RECORD
From: "David Durst" <ddurst@larubber.com>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Reply-To: ddurst@larubber.com
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/413
X-Sequence-Number: 11278

I recieve this error when executing the following function:

select lookup_journal_entries(to_date('20030125','YYYYMMDD'),
                              to_date('20030125','YYYYMMDD'));

Here is the function itself:

create function lookup_journal_entries(date,date) returns setof journal as '
select * from journal where entry_date >= $1 OR entry_date <= $2'
language 'SQL';

Normally I would expect to see a pointer # returned from the above select
but instead I get this error.