Postgres Pro
Downloads
Home   >   mailing lists

Re: Record variable not behaving as expected (bug?) - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Record variable not behaving as expected (bug?)
Date
Msg-id 20071130085018.GC27784@svana.org
Whole thread Raw
In response to Record variable not behaving as expected (bug?)  ("Postgres User" <postgres.developer@gmail.com>)
Responses Re: Record variable not behaving as expected (bug?)  ("Postgres User" <postgres.developer@gmail.com>)
Re: Record variable not behaving as expected (bug?)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy
Attachment

pgsql-general by date:

Previous
From: "Postgres User"
Date:
Subject: Record variable not behaving as expected (bug?)
Next
From: "Usama Dar"
Date:
Subject: Re: can't createdb with my new user