| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Postgres User <postgres(dot)developer(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Record variable not behaving as expected (bug?) |
| Date: | 2007-11-30 16:13:19 |
| Message-ID: | 2715.1196439199@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> 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.
Works for me too, in all branches back to 8.0. However, I noticed that
the test function references "test.table2" not just "table2", which
makes me wonder if maybe this is picking up some other table2 than the
OP thinks. A test.table2 with integer columns would explain the result.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Postgres User | 2007-11-30 16:20:30 | Re: Record variable not behaving as expected (bug?) |
| Previous Message | Gregory Stark | 2007-11-30 16:06:38 | Re: postgresql table inheritance |