[GENERAL] sql expert full time help wanted

http://seeker.dice.com/jobsearch/servlet/JobSearch?op=101&engine=2&dockey=xml/7/4/[EMAIL PROTECTED]&source=19&FREE_TEXT=keibi .V

[GENERAL] repost(gmane): sql update max smartries

I am trying to write a sigle command to update the max number from detail. Something like: update group set max_msgid=max(c.msgid) from group g, content c where g.id=c.g_id So group is master, content is detail. I want group to stroe max(msgid) from content. Syntax help plz? .V -

[GENERAL] sql update max smartries

I am trying to write a sigle command to update the max number from detail. Something like: update group set max_msgid=max(c.msgid) from group g, content c where g.id=c.g_id So group is master, content is detail. I want group to stroe max(msgid) from content. Syntax help plz? .V --

Re: [GENERAL] repost(gmane): sql update max smartries

Vic Cekvenich wrote: I am trying to write a sigle command to update the max number from detail. Something like: update group set max_msgid=max(c.msgid) from group g, content c where g.id=c.g_id So group is master, content is detail. I want group to stroe max(msgid) from content. Syntax

[GENERAL] pre-sroted table (w/ index)

In TransacSQL, we used to have the tabled sorted by marking an index for example by create_date. This way we did not need to do an order by or at least it was faster. Is there a way to force the table to be physicaly stroed sorted by a certain index? tia, .V ---(end of b

[GENERAL] OS X Mac pgAdmin equivalent?

What can I run on OS X as a pgAdmin equivalment (other than the Java solutions)? .V -- Please post on Rich Internet Applications User Interface (RiA/SoA) ---(end of broadcast)--- TIP 7: don't forget to increase your free s

Re: [GENERAL] Text Search vs MYSQL vs Lucene

It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge raid striped drives as single volume. A similar system and types of querries would be this: http://marc.theaimsgroup.com So I guess a table scan. .V Shridhar Daithankar wrote: On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich

[GENERAL] Text Search vs MYSQL vs Lucene

What would be performance of pgSQL text search vs MySQL vs Lucene (flat file) for a 2 terabyte db? thanks for any comments. .V -- Please post on Rich Internet Applications User Interface (RiA/SoA) ---(end of broadcast)---

[GENERAL] Text search performance vs MY SQL

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, .V -- Please post on Rich Internet Applications User Interface (RiA/SoA) ---(end of broadcast)--- TIP 6: Ha

[GENERAL] news server question

This is not a postgreSQL question: How do you syncronize the news server with the mail list? Vic ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]