RE: [SQL] Temp tables being written to disk. Avoidable?

temp table, which is been using fairly frequently and makes the thing grind away. -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park RoadPhone: (02) 9870 4718 North Ryde NS

RE: [SQL] Temp tables being written to disk. Avoidable?

nsive. I imagine that could vary heavily on the contents of the tables and the number of concurrent searches that are occuring. Thanks again. -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.a

[SQL] Temp tables being written to disk. Avoidable?

tables sit in memory. Hmm, I should to do some proper benchmarking on this rather than worrying about the noises coming from the disks.. However, even if the original method does turn out to be faster, I imagine it could be faster still without the disk writes (though I don't know anywhere nea

[SQL] Checking for existence of table

Hello, Is it possible to check for the existence of a table within PL/pgSQL? Would select count(*) from pg_class where relname='name' and reltype='0' be the answer to this question? -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http:

Re: [SQL] MAX() of 0 records.

ggregate function?) would cause an implicit grouping to occur around a null field which the backend doesn't like. I'd read Tom's post if you are interested though, it probably makes more sense! -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://w

[SQL] MAX() of 0 records.

AND item.item_live = 't')>0 THEN UPDATE ... =MAX() ... ELSE UPDATE SET ... =0 ... END IF ? Thanks -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park Road

Re: [SQL] ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext

attached some SQL which sets up tables and generates the ExecEvalAggref I was getting in case it is of any use to anyone. Cheers. -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park R

Re: [SQL] ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext

Paul McGarry wrote: > If I do a 'SELECT * from view_name' and get 8 rows of data, when I > do a 'SELECT count(*) from view_name' I get 8 rows of the > number 1 returned. I've attached a script which will generate a bunch of tables and a view then do a select

Re: [SQL] ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext

of the number 1 returned. In any case I'll try and distill both of these down to a slightly less horrific testcase and send it in. -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6

[SQL] ERROR: ExecEvalAggref: no aggregates in this expression context

s minprice, max (item.item_price) as maxprice when the entry_view view is defined? Thanks -- Paul McGarrymailto:[EMAIL PROTECTED] Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park RoadPhone: (02)