Re: Problems with PQfmod() returning -1 on varchar f

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jerry Day <jerry_day(at)esri(dot)com>, "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Problems with PQfmod() returning -1 on varchar f
Date: 2005-04-10 04:28:24
Message-ID: 200504100428.j3A4SOH28330@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Tom Lane wrote:
> > SELECT a.data,a.int16_col,a.int64_col,a.float32_col,
> > a.float6_col,a.date_col,a.row_id
> > FROM table2 a
> > LEFT JOIN
> > (SELECT *
> > FROM table3
> > ) d ON (a.ROW_ID = d.ROW_ID)
> > WHERE d.ROW_ID IS NULL
> > ) V__282 LIMIT 0;
>
> The UNION will drop the typmod, even if both its inputs have the same
> typmod. See e.g.
> http://archives.postgresql.org/pgsql-general/2005-04/msg00204.php
>
> This is on the agenda to look at for 8.1 ...

This is not on the community TODO? Is it on yours? Should it be on the
communties?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message mps 2005-04-11 00:15:10 pg.py under Mac OS X
Previous Message Vlad 2005-04-08 23:38:11 Re: [Dbdpg-general] benchmarking old Pg and DBD::Pg