Many thanks, Tom.
I wish I had known "\pset null nil" trick.
It would have saved a few unnecessary emails.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wed 7/1/2009 10:42 AM
To: Tena Sakai
Cc: Rob Sargent; pgsql-sql@postg
Tim Haak writes:
> I am running the following query again a partitioned table in 8.2.7. It
> does index scans which is unexpected as there are indexes for the
> log_date column.
The index min/max optimization only works on single tables at the
moment. Sorry.
regards, t
"Tena Sakai" writes:
>> So they were null,
> Yes!
>> and null turns out to be a seven-character blank string!?
> I don't understand how that happens. Mr Tom Lane
> hinted that it might be a bug in sprintf...
Well, that was before I read the messages where it turned out that they
were actually
Hi
I am running the following query again a partitioned table in 8.2.7. It
does index scans which is unexpected as there are indexes for the
log_date column.
min(log_date) from data.table
"Aggregate (cost=739932.02..739932.02 rows=1 width=8)"
" -> Append (cost=0.00..685106.21 rows=219303
Hi Rob,
> So they were null,
Yes!
> and null turns out to be a seven-character blank string!?
I don't understand how that happens. Mr Tom Lane
hinted that it might be a bug in sprintf...
> Btw, you can change the displayed value of null with
> \pset null nil
> and you will seem 4+ million
Hi,
I have been developing in postgresql for a very short time. I am
currently having problems that I believe can be resolved with the right
query structure but as of yet have not been able to figure it out.
I am using xpath(xpathExpression, xml, Array[Array[]]) function form
8.3.7 (This is the v
So they were null, and null turns out to be a seven-character blank string!?
Btw, you can change the displayed value of null with
\pset null nil
and you will seem 4+ million 'nil's in your output
Tena Sakai wrote:
Hi Osvaldo,
> Try:
> SELECT count(*) FROM gallo.sds_seq_reg_shw;
> SELECT c
