[SQL] Help on Union Query

on (Node_ID) Node_ID from NodeIndex where word='[a word]' union select count(*) from NodeIndex where Node_ID in (select distinct on (Node_ID) Node_ID from NodeIndex where word='[a word]') order by count; Any assistance would be appreciated. Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] Like Query on BLOB's

Hi, Does anyone know if it's possible to do a like query on an oid (blob)? Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] Postgresql Site Search

Considering postgresql performs so well for me here, why is the postgres site search so fucking slow??

[SQL] Large Objects

Hi, Could someone please provide a demo of creating the type "Lo". Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] COUNT

Hi, How do I get a row count, like "Select [COUNT] from Table" ?? Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] JDBC Performance

object to perform multiple queries, so i have changed the application to create additional Connections. This has reduced it's performance around 400%. I'm using the driver contained with Postgresql 7.1 Does anyone have ideas on increasing performance with multiple connections? Kin

[SQL] Windows 9X

Hi, Has anyone installed postgresql on a box running Win9X, if so, could you provide some pointers on getting started. Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] createuser

Hi, I'm having trouble with the createuser command. createuser -adq username returns invalid option adq Could someone post an example using these args. Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] currval

g via jdbc, I'm getting no results back (null pointer). Has anyone experienced this and have a solution? Regards, Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] Join

Hi, I'm having trouble with this statement, could someone help out please. Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where eg.Entity_ID=1 The error message is: ERROR: transfromExpr: does not know hot to transfrom node 501 (internal error) Craig May

[SQL] Trigger

Could someone send me a quick example of a trigger.

[SQL] Cascading Deletes

h the chain. For example: 0 0 Base 1 0 Sib1 2 0 Sib2 3 0 Sib3 4 1 Sib1_1 5 1 Sib1_2 Deleting Base would remove all the entries. Deleting Sib1 would delete Sib1_1 and Sib1_2. Can anyone help out here? Regards, Craig May Enth Dimension http://www.enthdimension.com.au

Re: [SQL] pg_hba.conf

Found it! The file should be located in /var/lib/pgsql/data/ Thanks for your help all =) Craig May Enth Dimension http://www.enthdimension.com.au On Tue, 05 Sep 2000 11:11:25 Craig May wrote: > Ok, > > Here are all the details: > > Redhat 6.1 > pgsql 7.0 > Firew

Re: [SQL] pg_hba.conf

from localhost. Finally, I have restarted the postgresql service between every change. Regards. Craig May Enth Dimension http://www.enthdimension.com.au On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote: > Craig May wrote: > > > I've renamed the file to "pg_hba.conf". It&

Re: [SQL] pg_hba.conf

I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres. The file is located in /usr/lib/pgsql/. I'm still receiving the same error. On Mon, 04 Sep 2000 07:47:08 Christopher Sawtell wrote: > On Tue, 05 Sep 2000, Craig May wrote: > > H

[SQL] pg_hba.conf

Hi, I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database XXX." I've modified the pg_hba.conf.sample file to allow all access, however still getting the same message. Any suggestions? Regards, Craig May

[SQL] Database Transfer

Hi, I have two servers running pgsql. Is there a command to transfer the databases between them? Craig May Enth Dimension http://www.enthdimension.com.au

[SQL] @@Identity

Does anyone know if there is an equivalent statement to SQL Servers select @@Identity?