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
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 |