Ian,
Thanx - I figured the same about the ambiguity. I'll keep tryin' to
debug this with the vendor, then.
-Brice
Ian Harding wrote:
>
> Brice Ruth wrote:
>
> > Greetings.
> >
> > I'm working with a product provided by a third part that interface
query or not. Please
advise.
Any help will be (as always) sincerely appreciated.
--
Brice Ruth
WebProjkt, Inc.
VP, Director of Internet Technology
http://www.webprojkt.com/
d='2008' AND
Query3: versionid='FDB-PE' AND
Query3: category='PEM';
To my knowledge, Query1 is the join that should produce the same results
as the manual join represented by queries 2 & 3.
What's going on?
-Brice
Ian Harding wrote:
>
> Brice Ruth
/var/log/postgresql appears to be empty as well.
-Brice
"Brett W. McCoy" wrote:
>
> On Wed, 7 Feb 2001, Brice Ruth wrote:
>
> > Is there any way (besides ps) to view queries that are running on the
> > PostgreSQL server? Something that actually output the que
Cool, that worked. Thank you.
-Brice
"Brett W. McCoy" wrote:
>
> On Thu, 8 Feb 2001, Brice Ruth wrote:
>
> > Its not working ... I looked at the admin docs and edited the pg_options
> > file appropriately ... the following is what appears in /var/log/m
ment efficiently enough.
If it would help anyone to see the query plan or such - I can modify the
logs to show that, just let me know.
Btw - I've let this query run for a while & I haven't seen it complete
... s ... I don't know if it would ever complete or not.
Any help
/
256MB RAM.
This is just meant as an FYI.
-Brice
Brice Ruth wrote:
>
> The following query:
>
> SELECT
> tblSIDEDrugLink.DrugID,
> tblSIDEDrugLink.MedCondID,
> tblMedCond.PatientName AS MedCondPatientName,
> tblMedCond.ProfessionalName AS
u Feb 8 10:17:09 2001
Terminating any active server processes...
Server processes were terminated at Thu Feb 8 10:17:09 2001
Regards,
Brice Ruth
Brice Ruth wrote:
>
> The following query:
>
> SELECT
> tblSIDEDrugLink.DrugID,
> tb
ly selects.
-Brice
Stephan Szabo wrote:
>
> What does explain show for the query and have you run
> vacuum analyze recently on the tables?
>
> On Thu, 8 Feb 2001, Brice Ruth wrote:
>
> > The following query:
> >
> > SELECT
> >
rice
Stephan Szabo wrote:
>
> After you load the data, you need to run vacuum analzye. That'll
> get statistics on the current data in the table. Of course, I'm
> not sure that'll help in this case.
>
> On Thu, 8 Feb 2001, Brice Ruth wrote:
>
> > Stepha
ly be improved to:
return ((c == 't') || (c == 'T') || (c != '0'));
and in that way any result is 'true' and only '0' returns false (for SMALLINT).
Regards,
Brice Ruth
Brice Ruth wrote:
>
> Here's a code snippet tha
f '1'
as 'true' when returned from getBoolean(). Is this a bug in the driver
for PostgreSQL? Any help would be appreciated!
See original message below for background & further details of the problem.
TIA & Best Regards,
Brice Ruth
(Original Message)
Greetings.
I&#x
12 matches
Mail list logo
