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: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Record variable not behaving as expected (bug?)
Date: 2007-11-30 08:50:18
Message-ID: 20071130085018.GC27784@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 30, 2007 at 12:23:31AM -0800, Postgres User wrote:
> However, I have found that my record variable is not assigned proper
> field-level datatypes. As a result, I'm unable to write basic math
> calcs in pg/sql without a lot of typecasting.

What version are you running. On my 8.1.9 test system it returns -1.00
as expected.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2007-11-30 09:14:14 Re: [GENERAL] Empty arrays with ARRAY[]
Previous Message Postgres User 2007-11-30 08:23:31 Record variable not behaving as expected (bug?)