Paul Lambert wrote on 06.02.2007 23:44:
Sort on Weenblows is a bastard to work with, and I don't believe it has
a unique option. I probably should have mentioned this was on Weenblows.
You can get all (or most?) of the *nix/GNU commandline tools for Windows as
well. As "native" Win32 progra
As the table definitions get updated frequently, I'd like to put in my
script to create the table as a copy of the existing 'real' table. I'm
assuming "create table as" would be what I need to use, but what would I
use as the select sql - i.e. how do I use select to pull the definition of
a tab
Andrew Sullivan wrote:
On Wed, Feb 07, 2007 at 07:15:02AM +0900, Paul Lambert wrote:
I'm assuming the best way to get around this is to load the data into a
temporary table with "copy from" and then do a "select distinct into" my
real table.
You might find that sort|uniq at the command prompt
On Wed, Feb 07, 2007 at 07:15:02AM +0900, Paul Lambert wrote:
>
> I'm assuming the best way to get around this is to load the data into a
> temporary table with "copy from" and then do a "select distinct into" my
> real table.
You might find that sort|uniq at the command prompt would be better.
I have some tables which I need to load from flat data files that can
contain upwards of five million rows.
It's possible (owing to the structure of the system the data is
originating from) that on occasion the data extract that generates these
flat files can include two records that have the
Hiltibidal, Robert wrote:
Keep in mind that 2/3 of the inserts are actual log entries. 1/3 are for
supporting information like ip, query string values etc.
The table is a "star" table.
You are correct tho in terms of time.. When I did the same application
with fpc pascal (http://www.freepasca
Hiltibidal, Robert wrote:
> I am getting this error
I thought you were supposed to post in pgsql-general ...
> make -C port all
>
> make[3]: Entering directory
> `/db2/logs/downloads/postgres/postgresql-8.2.1/src/backend/port'
>
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
> -
Hiltibidal, Robert wrote:
Morning
I currently use DB2 on an AIX 5.2 p5 platform 7gb ram for log analytics
with heavy OLAP querying.
Index ANDing in DB2 allows for multiple indexes to be used in joins. I'm
not sure of the ORing function yet.
That's what 8.1+ support. The bitmap is in-memory th
sneumann wrote:
Hi,
I have a PL/pgsql function that creates a certain bit string
based on the parameters. Things work fine if I use bit(10)
throughout the function. Now I'd like to return a bit string
with the given size "len", but that breaks with a syntax error:
ret := B'0'::bit(len
Hiltibidal, Robert wrote:
Is this a good group to post compilation errors to?
Probably better with pgsql-general
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hiltibidal, Robert wrote:
Does postgres have support for index ANDing and index ORing?
Well, 8.1+ will create an on-the-fly bitmap for x=1 AND y=2 type of queries.
What were you thinking for ORing?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)--
Hi...
I tried this its working.. can u please check this.
select count(*) as all, sum(decode(entry_user_id,'VC',1)) as
entry_user_id,sum(decode(entry_user_id,'VE',1)) as VE
,sum(decode(entry_user_id,CV,1))as
CV,sum(decode(entry_user_id,'SC',1))as SC from vigilance_master;
regards
penchal
-
12 matches
Mail list logo
