l-sql
regards, Ries van Twisk
-
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: r...@vantwisk.nlweb: htt
nsitivity (try ILIKE)
regards, Ries van Twisk
---------
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: r...@van
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
On Mar 3, 2009, at 3:26 PM, Emi Lu wrote:
Good morning,
Would it be possible to know that whether "union" is quicker than
"left join" in a general sense?
Queries:
(1) union
select a.*, b.value
from a
left join b
union
select a.*, c.value
from a
left joi
On Nov 28, 2008, at 8:51 AM, Lutz Steinborn wrote:
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock'
On Nov 24, 2008, at 2:12 PM, Tk421 wrote:
Hello everybody.
I've got an vb aplication that uses an Access database. I'm trying
to convert the database to postgres. The conversion was done ok, but
i've got a little problem that i don't know how to solve. Let's see
if anyone can help me
On Nov 18, 2008, at 5:48 PM, Ryan Wells wrote:
While looking through our data layer code today, I ran across this
query:
SELECT
tasks.*,
clients.FirstName,
clients.LastName,
clients.MiddleInitial,
iteminfo.CreatedBy,
iteminfo.StationId,
iteminfo.CreatedDate,
changelog.LastModified,
changelog
On Nov 5, 2008, at 8:42 AM, Hemant Patel wrote:
Hello Everyone,
I have a array of ids from my search result and now
I want to fetch the details from the database.
Now IN query is ruined my sort order.So should I go for Union All?
IN doesn't ruin your sort order really
On Sep 26, 2008, at 12:23 PM, Edward W. Rouse wrote:
Can I assume the missing ‘.”’ From the end of PG_PASSWORD is a cut
and paste error?
Edward W. Rouse
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of James Kitambara
Sent: Friday, September 26, 2008 1:22 AM
To: pgsql-sql
On Aug 29, 2008, at 5:33 PM, Michael B Allen wrote:
Hello,
I've been tinkering with SQL level access control for web
applications. Currently I have a UNIX style uid / gid for each record
and do a WHERE e.uid IN (10,20,30) where 10, 20 and 30 would be the
IDs
of groups the user is in.
Howev
Jodi,
get some of Joe Celco books for me they where extreemly usefull.
Ries
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
. Any hints will
be appreciated.
best reghards,
Ries van Twisk
<---
Here you find the output of the explain again:
I cannot yet read the output of explain si I'm not sure if the output looks
good or bad.
echo "VACUUM ANALYZE; EXPLAIN SELECT * FROM full_cablelist WHERE
pro
.
I ask this because I expect pore performance in feature when the cablelist
table holds up to around 20.000 rows.
Each query to full_cablelist will return around 1200 rows.
best regards,
Ries van Twisk
-- CABLE LIST
CREATE TABLE cablelist (
id SERIAL,
cableno
'.
In this way you can use the NOT NULL contsraint so the novice programmer can
work with actual values instead of 'forgetting' about the NULLS. This idea
can be helpfull for the novice database designer.
Just a thought...
Ries van Twisk
> -Oorspronkelijk bericht
of a domain table.
Anyway so far thangs for the quick responses, I've got something to work on.
best regards,
Ries van Twisk
-Oorspronkelijk bericht-
Van: Troy [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 3 december 2002 15:47
Aan: Ries van Twisk
CC: [EMAIL PROTECTED]
Onderwerp
Hi All,
is there any whitepaper, document or website that can point me to how to
setup a inventory system?
I'm particulary interested how other people solve the problem of a unknown
number of attributes to a inventory item.
example:
BAL<-- Inventory Item
- Color <- At
This is because '' is not equal to NULL
'' Means a empty string
NULL means a empty set
So this: SELECT * FROM tbl WHERE c1 IS NULL;
is totally different then: SELECT * FROM tbl WHERE c1='';
Ries
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Namens Ajit Ara
done using a regular
user but of course a update needs to be done within a acceptable time so the
user does not get annoyed.
best regards,
Ries van Twisk
> -Oorspronkelijk bericht-
> Van: Richard Huxton [mailto:[EMAIL PROTECTED]]
> Verzonden: maandag 16 september 2002 17:08
18 matches
Mail list logo
