Re: Record variable not behaving as expected (bug?)

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

In response to

Browse pgsql-general by date

  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