Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group