from securitytype
where position (upper('|' || sectype_in || '|' ) in
upper(securitytypeaka) ) > 0;
--
-- did not find a type above
if sectypekey is NULL then
select securitytypekey into sectypekey
from securitytype
where upper(securitytypeshort) = 'UNKNOWN';
end if;
return sectypekey;
end
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION getsectypekey(sectype_in bpchar) OWNER TO postgres;
Kevin Duffy
ce and thus
allowing the index on security to be used.
And of couse '5' makes things simple. The index on security is used.
Am I posting this in the right. If not please help me correct my error
and point me to the correct spot.
Thanks for taking a look at my issue.
Best Regards
Kevin Duffy
ot;Index Cond: ($0 = securitytypekey)"
So this proves it is using the index.
But I think the issue is in the interaction between the numbers of rows
returned from positions_gsco and security.
kd
-Original Message-
From: Klint Gore [mailto:[EMAIL PROTECTED]
Sent: Thurs
Hello:
I am move to a new production server and am testing my backup and
restore procedures.
Given a backup created with the follow command
C:\>C:\progFiles\PostgreSQL\8.2\bin\pg_dump -Fc -b -C -o -f
E:\backupPostgres\benchxx_c20080912.backup -U postgres benchxx_c
What is the best w
File(s) 1,300,220 bytes
0 Dir(s) 40,459,689,984 bytes free
C:\>
I have tried many variations of slashes and back-slashes, but nothing
works.
I am working within pgAdmin under Windows XP.
Please help me preserve my sanity. I do not see that I am doing wrong.
But I am certain it is very simple.
Best Regards
Kevin Duffy
Hello:
A follow up question that may clear this all up:
Is the 'filename' relative to the server machine or the client where
pgAdmin is running?
Kevin Duffy
WR Capital Management
40 Signal Rd
Stamford, CT
203-504-6221
If you wish to copy from the client machine you can use \copy within
psql.
b
Kevin Duffy wrote:
> Hello:
>
>
>
> A follow up question that may clear this all up:
>
>
>
> Is the 'filename' relative to the server machine or the client where
> pgAdmin is
error message was produced.
Strange.
Any suggestions.
Thanks in advance for your kind assistance.
Kevin Duffy
From: Jonathan Schindler
Sent: Wednesday, November 11, 2009 9:58 AM
To: Kevin Duffy
Subject: upgrade to 8.4 with new character set
To those that know,
We originally built our database with a character set of SQL_ASCII. We
now know the error of our
Hello:
I am try to get a function to return the count of the rows updated within
the function.
As in the following, I wan the number of rows updated to be returned.
This is a simple update, other update statements that I need to write will
be complicated.
CREATE OR REPLACE FUNCTION est_idio_retu
Hello:
I have run into a very frustrating problem.
I have a database with some tables which were loaded from Excel spreadsheets
via a Perl script. Guess that does not really matter. The table
definitions
are below.
Both tables contain 9,398,340 rows
On a machine running Windows 7 64Bit with
500, Kevin Duffy wrote:
> > [...]
> > I have run into a very frustrating problem.
> >
> > I have a database with some tables which were loaded from Excel
> spreadsheets
> > via a Perl script. Guess that does not really matter. The table
> > definitions
onstraints and allow the new table structure to be created and then
populated with new data.
I have not changed the keys of existing records so that existing
relationships should be restored.
Thanks for considering my issue.
Kevin Duffy
13 matches
Mail list logo
