From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Postgres User <postgres(dot)developer(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Record variable not behaving as expected (bug?) |
Date: | 2007-11-30 21:55:39 |
Message-ID: | 20071130215539.GJ27784@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Nov 30, 2007 at 12:34:57PM -0800, Postgres User wrote:
> Sorry, here's the code:
<snip>
The code you posted won't work on a blank database, I needed to delete
the test prefix to table2. I've adjusted it to be hopefully what you
did. My output is:
---
CREATE TABLE
CREATE FUNCTION
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.9 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)
divide
--------
-1.00
(1 row)
DROP FUNCTION
DROP TABLE
---
Can you try the attached script on a *nlank* database? It'll give us
more info about your system.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
Attachment | Content-Type | Size |
---|---|---|
divide.sql | text/plain | 649 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2007-11-30 23:15:27 | Re: Linux v.s. Mac OS-X Performance |
Previous Message | Pavel Stehule | 2007-11-30 21:41:01 | Re: PL/pgSQL and SETOF |